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)  ...
  • Naveen29's avatar
    Naveen29
    4 years ago

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