Forum Discussion

mclawler's avatar
mclawler
Helper III
3 years ago

MoM % Variance

Hi Everybody, first post, I am a rookie at this stuff and for the life of me can't seem to figure out the correct DAX for MoM % Variance.  I'm self-taught and done pretty well so far, but I must be m...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi mclawler 

You can reger to the following measure

 

MTM% = var a=SUMX(FILTER(ALLSELECTED('Table'),EOMONTH('Table'[Snapshot month],0)=EOMONTH(MAX('Table'[Snapshot month]),1)),[Exposure Balance])
return DIVIDE(a-SUM('Table'[Exposure Balance]),SUM('Table'[Exposure Balance]))

 

 

 

Best Regards!

Yolo Zhu

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

  • mclawler's avatar
    mclawler
    Helper III
    3 years ago

    Your DAX did exactly as your chart shows, however I don't think it's giving me the results I'm looking for.  

     

    For example -

    from 2/1/2022 to 3/1/2022 I'm looking for a -50%

    from 3/1/2022 to 4/1/2022 I'm looking for 39.6%

    from 4/1/2022 to 5/1/2022 I'm looking for 0%

    from 5/1/2022 to 6/1/2022 I'm looking for 497%

     

    Current month divided by previous month for the increase/decrease %

     

    Thank you!