Dynamic 6 weeks

[pravallikag]

Dimension	Weeks
WorkCntr	1-28	29	30	31	32	33	34	35	36	37	38	39	40
	Actuals	Actuals	Actuals	Running total	Running total	Running total	Running total	Running total	Running total	Actuals	Actuals	Actuals	Actuals

Hai I wanted to create Dynamic 6 Weeks Running total , 
I have attached the table for giving requirement,
My Client wanted to see the Workcntr as a rows and Weeks in a column level and values
I wanted to create Dynamic 6 Weeks Running total values
Currently we are in 31st week so it would automatically should give next 6 weeks running totals so(31,32,33,34,35,36) after this 6 weeks it should show only actuals ie(37 to 53) and it should be dynamic ie if we are in 37 th week it should dynamically create next 6 weeks value


Thanks 
Pravallika

[rubayatyasmin]

hey, @pravallikag 

I found a similar thread

Solved: Calculating a dynamic 6 week run rate - Microsoft Fabric Community