Want to show Value for next 90 days from current month

[AshDil]

Hi,

I have 2 tables, table-1 has actual values till current month(Sep 2021) . Table-2 has forecast values from July 2021. 

I want to show actual values sum from Jan 2021 to till date (Sep 2021) which is nothing but YTD, and also want to show forecast values from current month to next 90 days by subtracting current month actual values.

Please help me to do.

Thanks,

AshDil.

[Ashish_Mathur]

Hi,

Share some data and show the expected result.

[AshDil]

Hi @Ashish_Mathur ,

Please find the Sample input and output.

Table-1:  Actual Values

CAT	YEAR	JAN	FEB	MAR	APR	MAY	JUNE	JUL	AUG
A	2021	100	120	150	200	300	250	400	200
B	2021	120	300	120	130	250	500	100	600

Table-2: Forecast Values

CAT	YEAR	JUL	AUG	SEP	OCT	NOV
A	2021	100	150	200	300	250
B	2021	200	150	400	300	350

Expected Output:

CAT	ACTUAL YTD	90 DAY FORECAST
A	1720	750
B	2120	1050

Please help me to do.

Thanks,

AshDil

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[AshDil]

Hi @Ashish_Mathur ,

It worked for me. Thanks for your help.

[Ashish_Mathur]

You are welcome.