Forum Discussion
System Date / between filter for 2 different years
Dear all, I am trying to create 2 measures to calculate revenue for 2 different years. 1st : CY Revenue = CALCULATE(SUMX (revenue(field) , filters ) this is correct 2nd : PLY (previews last ye...
like this
Sheet1 = main table
Hi SpiroswayGR ,
The first method is to use the date field of the calendar table in the slicer, and the second method is to use the date field of the main table in the DAX formula.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.