How to get rolling actual data in My Matrix?

Question

Hi All,&nbsp;I have 2 data sets. The first one is my forecast and the second dataset has actuals.Forecast DatasetReport Date, Timeline date, Forecast Qty&nbsp;Actual DatasetReport Date, Timeline Date, Actuals QtyI want to create a waterfall matrix where I need to show all my Forecast Qty (Black font), the Actuals (Red fonts), and totals (Blue fonts)The output should be as below table:Report DateJanFebMarAprMayJunJulAugSeptTotalJan10020030050250&nbsp;&nbsp;&nbsp;&nbsp;900Feb9020250100400300&nbsp;&nbsp;&nbsp;1160Mar9040500402100302288&nbsp;&nbsp;1722Apr9040400700650300100500&nbsp;2780May90404009002002002002002002430Could anyone please help me in creating this output?Thanks in advance.

v-lianl-msft · Answer

Hi Anonymous&nbsp;,
&nbsp;
Maybe you can create measure to meet your needs, but it depends on your data model.
Can you paste the sample data and let me do more tests to see if I can solve your problem
&nbsp;
Best Regards,LiangIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

anonymous · Answer

Hi&nbsp;V-lianl-msft&nbsp;The 2 data sets which I have explained above, Using that I have created a third table. Now I have forecast and actual qty in one column.&nbsp; I just want my last column values to repeat till the end of the table. I am not able to repeat the last values. It will be really helpful if you can able to find any solution.Report DateTimeline DateSourceQty1-Jan1-JanForecast Table1001-Jan1-FebForecast Table2001-Jan1-MarForecast Table3001-Jan1-AprForecast Table501-Jan1-MayForecast Table2501-Feb1-FebForecast Table201-Feb1-MarForecast Table2501-Feb1-AprForecast Table1001-Feb1-MayForecast Table4001-Feb1-JunForecast Table3001-Mar1-MarForecast Table5001-Mar1-AprForecast Table4021-Mar1-MayForecast Table1001-Mar1-JunForecast Table3021-Mar1-JulForecast Table2881-Apr1-AprForecast Table7001-Apr1-MayForecast Table6501-Apr1-JunForecast Table3001-Apr1-JulForecast Table1001-Apr1-AugForecast Table5001-May1-MayForecast Table2001-May1-JunForecast Table2001-May1-JulForecast Table2001-May1-AugForecast Table2001-Feb1-JanActual Table901-Mar1-FebActual Table401-Apr1-MarActual Table4001-May1-AprActual Table900&nbsp;Thanks in advanceAD

Forum Discussion

How to get rolling actual data in My Matrix?

2 Replies

Related content

Rolling accumulation

Rolling accumulation

Matrix Row Filtering Alters Rolling DATESINPERIOD Measures

Rolling Date Identifiers

Matrix table

Report Date	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sept	Total
Jan	100	200	300	50	250					900
Feb	90	20	250	100	400	300				1160
Mar	90	40	500	402	100	302	288			1722
Apr	90	40	400	700	650	300	100	500		2780
May	90	40	400	900	200	200	200	200	200	2430

Report Date	Timeline Date	Source	Qty
1-Jan	1-Jan	Forecast Table	100
1-Jan	1-Feb	Forecast Table	200
1-Jan	1-Mar	Forecast Table	300
1-Jan	1-Apr	Forecast Table	50
1-Jan	1-May	Forecast Table	250
1-Feb	1-Feb	Forecast Table	20
1-Feb	1-Mar	Forecast Table	250
1-Feb	1-Apr	Forecast Table	100
1-Feb	1-May	Forecast Table	400
1-Feb	1-Jun	Forecast Table	300
1-Mar	1-Mar	Forecast Table	500
1-Mar	1-Apr	Forecast Table	402
1-Mar	1-May	Forecast Table	100
1-Mar	1-Jun	Forecast Table	302
1-Mar	1-Jul	Forecast Table	288
1-Apr	1-Apr	Forecast Table	700
1-Apr	1-May	Forecast Table	650
1-Apr	1-Jun	Forecast Table	300
1-Apr	1-Jul	Forecast Table	100
1-Apr	1-Aug	Forecast Table	500
1-May	1-May	Forecast Table	200
1-May	1-Jun	Forecast Table	200
1-May	1-Jul	Forecast Table	200
1-May	1-Aug	Forecast Table	200
1-Feb	1-Jan	Actual Table	90
1-Mar	1-Feb	Actual Table	40
1-Apr	1-Mar	Actual Table	400
1-May	1-Apr	Actual Table	900