Forum Discussion
Rate of % Change
Hi guys! Need your help. I'm struggling to formulate the % change in D A X. I'm trying to have a measure for Daily, Week of the year, Monthly, Quarterly and yearly for comparative purposes. This is...
Depends on goals. If there were no sales on previous date and blank is returned, that's correct.
If compare to the latest date before current when sales were, you may filter on max date in fact table before current date in calendar table.
If compare to the same date in previous month that will be another measure, etc. Period comparasion patterns are here https://www.daxpatterns.com/time-patterns/