Clustered Column Chart: Calculate average based on value of another column
Budget: $10 – $30 USD
I have a table with two columns: Date, Days and Batch.
I need, in Power BI, a Clustered Column Chart with three columns: Average Days, Average Days when Batch = 0, Average Days when Batch = NULL.
The first column, Average Days, is easy, and already implemented with monthly date bins (see attached). I'm attempting to stack two additional columns per month with the aforementioned metrics.
This is a short and simply project. Please do not bid this out. Please read the requirements before reaching out to me. I will check back in a few hours from the time I post.
I need, in Power BI, a Clustered Column Chart with three columns: Average Days, Average Days when Batch = 0, Average Days when Batch = NULL.
The first column, Average Days, is easy, and already implemented with monthly date bins (see attached). I'm attempting to stack two additional columns per month with the aforementioned metrics.
This is a short and simply project. Please do not bid this out. Please read the requirements before reaching out to me. I will check back in a few hours from the time I post.