Matrix with date columns and a measure

[wfarrell19]

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. 

[YukiK · Accepted solution]

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:

 

[wfarrell19]

It'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.