Forum Discussion

MiroVranes's avatar
MiroVranes
Frequent Visitor
3 years ago

MoM DAX

Month on Month = CALCULATE([Sales2],PREVIOUSMONTH(SQLResultTmp[Datum])) when I try to calculate MoM I get empty column.
 

 

I also tried with 

Sales last month1 = CALCULATE('SQLResultTmp'[Sales2],PARALLELPERIOD(SQLResultTmp[Datum],-1,MONTH))
but I've got only last figure 403.734.051,42 - 50.535.721,54 = 353.198.330 without previous monthly figures.

 Please help.

Thank you in advance.

 

Kind regards,

Miro

Need Help

4 Replies

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Community Support
    3 years ago

    Hi MiroVranes ,

     

    OK, please note that when the physical date field of the table should be the field you specify when using PREVIOUSMONTH.

     

    In your case, you should use the Month in the PREVIOUSMONTH( field ) the same as the Month used in the table visual( below).

     

    Best Regards

    Community Support Team _ chenwu zhu

     

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

    • MiroVranes's avatar
      MiroVranes
      Frequent Visitor
      3 years ago

      Hi,

       

      I hope I did as you have instructed. Please see result. What is problem now?

       

      Kind regards,

      Miroslav

    • MiroVranes's avatar
      MiroVranes
      Frequent Visitor
      3 years ago

       

      More info. Maybe it could help you to see what is problem.