Dynamic 6 weeks

Question

DimensionWeeksWorkCntr1-28293031323334353637383940&nbsp;ActualsActualsActualsRunning totalRunning totalRunning totalRunning totalRunning totalRunning totalActualsActualsActualsActuals&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Hai I wanted to create Dynamic 6 Weeks Running total ,&nbsp;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 valuesI wanted to create Dynamic 6 Weeks Running total valuesCurrently 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 valueThanks&nbsp;Pravallika

rubayatyasmin · Answer

hey,&nbsp;pravallikag&nbsp;&nbsp;I found a similar threadSolved: Calculating a dynamic 6 week run rate - Microsoft Fabric Community&nbsp;

Forum Discussion

Dynamic 6 weeks

1 Reply

Related content

Last 6 Weeks

Dynamic 4-Week Lookback from One Date Slicer

Rolling 6 Week Average

Dynamic Filter

Dynamic week cycles

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