Forum Discussion
Difference Measure between filtered column values in a matrix
Hi, There could be a suggestion for this elsewhere, but I've been searching for a while and not found anything! I pull an export from a system every week, the spreadsheet is named the date of the...
Hi Greg,
Thanks for your quick response. Have I understood you correctly by using this measure for the first example:
Measure = CALCULATE('Data Usage'[Total Usage],PREVIOUSMONTH('Data Usage'[Export Date].[Date]))
That one didn't display any values in the matrix:
v-easonf-msft
Community Support
Community SupportHi , EuanKonnektis
There's nothing wrong with Greg_Deckler solution.
I suspect you didn't use the correct calendar table.
"Previousmonth" is a time intelligence function that needs to be used with the calendar table of consecutive date columns.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.