Forum Discussion
Rolling Interval Calculation
Hi, My dataset is as follows Year Month Day_of_Month Values . . . . 2017 12 31 ...
Can you show a screen shot or share your file? You may need to created a disconnected table
Hi LivioLanzo,
I have attached Power BI File and Excel data source.
Value Rolling Average RI is the final required measure.
It gives correct data values when i select the complete data set that is year 2017 and 2018 both.
If i select only 2018 and check data values for rolling interval-1 , Month-January-2018 (i.e data for past 30 days) , it shows incorrect results because data for dec-2017 is filtered out.
I want it work with the side filters that is if user wants to select only one month and view data , it should give correct rolling average.
Please let me know if the attachment does not open.