Forum Discussion
Advocate IIMatrix with date columns and a measure
Hello,
I have a matrix with a date field as my columns and sales as my values. I'd also like to display a measure (such as an average or %) at the end in the total column, but I do not want that measure being displayed every month in the matrix. Often times I'm asked to provide something like monthly sales for each month with an average or % at the end next to the total column. Is there a way to do this in Power BI? I've attached an Excel example of how I would prefer it to work in Power BI.
I don't know if there is a way to accomplish that, but you can show average at the total column or custom string showing both avg and sum.
I'd use a measure like this:
Your Measure =IF( ISINSCOPE( DateDim[Month] ), [Sum of Sales], "Sum: " & [Sum of Sales] & ", Avg: " & [Avg of Sales] )Output:
2 Replies
- YukiK
Impactful Individual
I don't know if there is a way to accomplish that, but you can show average at the total column or custom string showing both avg and sum.
I'd use a measure like this:
Your Measure =IF( ISINSCOPE( DateDim[Month] ), [Sum of Sales], "Sum: " & [Sum of Sales] & ", Avg: " & [Avg of Sales] )Output:
wfarrell19It's not exactly what I'm looking for, but since what I'm looking for doesn't seem to exist yet in Power BI, it's a decent work around.