Forum Discussion

mitull's avatar
mitull
Frequent Visitor
4 years ago
Solved

Help Required For Calculating Rolling Last 6 Month Average using DAX in Power BI

Hello Community,   I need your help in Power BI to create a Matrix just like below:     I have created DAX formula to calculate value for [Jan-21] to [Dec-21]. Now, I am facing challenges ...
  • ValtteriN's avatar
    ValtteriN
    4 years ago

    Hi,

    For calculating last 6m months you can use this kind of structure. Here I am using a calculation group but for a measure just place your logic where there is SELECTEDMEASURE

    VAR _MaxDate = MAX( 'Calendar'[Date] ) RETURN CALCULATE(SelectedMeasure(), DATESINPERIOD( 'Calendar'[Date], _MaxDate, -6, MONTH ), ALL('Calendar') )

     I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

    My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

ValtteriN's avatar
ValtteriN
Community Champion
4 years ago

Hi,

For calculating last 6m months you can use this kind of structure. Here I am using a calculation group but for a measure just place your logic where there is SELECTEDMEASURE

VAR _MaxDate = MAX( 'Calendar'[Date] ) RETURN CALCULATE(SelectedMeasure(), DATESINPERIOD( 'Calendar'[Date], _MaxDate, -6, MONTH ), ALL('Calendar') )

 I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

mitull's avatar
mitull
Frequent Visitor
3 years ago

Hi ValtteriN 

 

Thank you very much for your quick help ! Your solution worked for me. 

 

Thanks again and stay blessed !!!