Forum Discussion

RichWyeth's avatar
RichWyeth
Frequent Visitor
9 years ago
Solved

Rolling Calculation

Hi,   I have a table as shown below that I would like to run some rolling months from. I am fairly new to Power BI and Dax so struggling a little. Ideally I would like to display a graph that has ...
Need Help
  • RichWyeth's avatar
    RichWyeth
    9 years ago

    Hi,

     

    Unfortunately this website is blocked by our internbet security, so I am unable to view.

     

    However, thanks to Bhavesh Patel, I have managed to understand the process more and seem to have found my solution:

     

    NEWTEST_C = CALCULATE([TotalWorkingDaysActual_M],
              DATESINPERIOD('KPI_ABS'[Month_Year],
                           LASTDATE('KPI_ABS'[Month_Year]),-11,MONTH
             ))

     

    This gives me the result I need each month.

     

    Thank you Bhavesh for your patience and help.

     

    Kind Regards

    Rich.

RichWyeth's avatar
RichWyeth
Frequent Visitor
9 years ago

Hi,

 

Unfortunately this website is blocked by our internbet security, so I am unable to view.

 

However, thanks to Bhavesh Patel, I have managed to understand the process more and seem to have found my solution:

 

NEWTEST_C = CALCULATE([TotalWorkingDaysActual_M],
          DATESINPERIOD('KPI_ABS'[Month_Year],
                       LASTDATE('KPI_ABS'[Month_Year]),-11,MONTH
         ))

 

This gives me the result I need each month.

 

Thank you Bhavesh for your patience and help.

 

Kind Regards

Rich.

BhaveshPatel's avatar
BhaveshPatel
Super User
9 years ago

Thank you Sir. Happy to hear that you found the solution. 

We are a great community of PowerBI.

 

 

 

Thanks & Regards,

Bhavesh