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...
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.
Hi v-easonf-msft - ahhh, fantastic, I see! My export date only has a date every week.
So do I need to have a consecutive date calendar date table that has a relationship with the export date column?
Many thanks,
Euan.