Solved: Rolling Calculation - Page 2

RichWyeth · ‎09-15-2016

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 a time filter, that will show the total number for the selected time period.

i.e. The WorkingDayActual_C would sum the numbers for the appropriate time span.

Am I able to do this just using this table? Do I need a date table to be linked and if so how would the formula work for this?

Any help would be very much appreciated.

RichWyeth · ‎09-16-2016

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.

View solution in original post