Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Prior Month YTD Issue

I am trying to work with 2 measures:  Current Month YTD and Prior Month YTD to have a final result with:  Current Month = [Current Month YTD]-[Prior Month YTD]   I am using the following dax co...
Need Help
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi Anonymous ,

     

    You can change measure Prior Month YTD using DAX below.

     

    Prior Month YTD = IF([Current Month YTD]=BLANK(),BLANK(),CALCULATE([Total Group Currency], DATEADD(Dates[Date], -1, MONTH), MONTH(Dates[Date])<>12))

     

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-xicai's avatar
v-xicai
Community Support
7 years ago

Hi Anonymous ,

 

You can change measure Prior Month YTD using DAX below.

 

Prior Month YTD = IF([Current Month YTD]=BLANK(),BLANK(),CALCULATE([Total Group Currency], DATEADD(Dates[Date], -1, MONTH), MONTH(Dates[Date])<>12))

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi, v-xicai 

     

    Thanks for your answer, I'm afraid that my total is still working wrong =(, now I do not see April any more but I'm not sure why the Total sum is still the same as before:

     

     

    Yessi

    • v-xicai's avatar
      v-xicai
      Community Support
      7 years ago

      Hi Anonymous ，

       

      Try to refresh , or you can try it again after updating to the latest version of Power BI Desktop 2.68.5432.841.

       

      Best Regards,

      Amy

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi v-xicai ,

         

        Currently in the company we have a previous version of PBI Desktop, I hope we have available the last one soon, then, I can check if that solves the problem.

         

        Thank you.

        Regards.

        Yessi 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    It works for me .Thanks.KG