Forum Discussion

Naveen29's avatar
Naveen29
Helper II
4 years ago
Solved

DAX Help

I have matrix visual which is having the combination of the FY, YTD ,MTD measures . The FY sales data should be whole year data regardless of the what you select in the slicer values (Year, Month)

 

FY Sales = CALCULATE (Sales, DATESYTD(ftcalendar[Date],"12/31")) - This should be constant value regardless of the Year, Month selection. This is not giving exact results. What is the best calucation for FY and previous financail year calucation measures.

 

 

  • I found the solution. FY Sales = TOTALYTD=(SALES, ENDOFYEAR(CALENDARDATE))

4 Replies