Forum Discussion
Measures for Time Intelligence/ Calculation Groups
Hello there, I am trying to create measures for Time Intelligence - However all my measures show me same values despite having proper formulae. I have a raw data which has 2 columns - fiscal year a...
Anonymous , For YTD you have try measures like
YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"07/31"))
Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"07/31"))
FY period and sort should do rest
:Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0