Forum Discussion
Solved
Previous YTD Help
Hi BI Community, I am trying to make a drillable matrix and visuals that show the current progress compared to last years progress. My formula is: Previous YTD = CALCULATE(TOTALYTD([total sal...
In your scenario, to see the indivual month data, you should create a YearMonth column first, then build a hierarchy like "Year->YearMonth->Date". Your Previous YTD will return correct result.
Regards,
In your scenario, to see the indivual month data, you should create a YearMonth column first, then build a hierarchy like "Year->YearMonth->Date". Your Previous YTD will return correct result.
Regards,
Ok, I made a hierarchy and included previousyear and that did the trick