Forum Discussion

SpiroswayGR's avatar
SpiroswayGR
Icon for Resolver III rankResolver III
5 years ago

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...
Need Help
SpiroswayGR's avatar
SpiroswayGR
Icon for Resolver III rankResolver III
5 years ago

v-lionel-msft thank you reply.

 

Well , model is almost same but with the difference of Sheet1.

Sheet1 should have Date  that is connected with Calendar Date. Also System Date in Sheet1 that is Entry Date that information imported to the system.

 

Maybe should i change connection calendar date to sheet1 system date to work ? 

v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi SpiroswayGR ,

 

Is your model like this?

 

You should add the dates in the fact table (Calendar table) to the slicer.

 

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.

 

 

  • SpiroswayGR's avatar
    SpiroswayGR
    Icon for Resolver III rankResolver III
    5 years ago

    like this

     

    Sheet1 = main table

    • v-lionel-msft's avatar
      v-lionel-msft
      Icon for Community Support rankCommunity Support
      5 years ago

      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.