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
Icon for Community Support rankCommunity 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