Forum Discussion
wfarrell19
Advocate II
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 tha...
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:
YukiK
Impactful Individual
Impactful IndividualI 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.