Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
AshDil
Helper V
Helper V

Want to show Value for next 90 days from current month

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.

 

1 ACCEPTED SOLUTION

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

5 REPLIES 5
Ashish_Mathur
Super User
Super User

Hi,

Share some data and show the expected result.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hi @Ashish_Mathur ,

Please find the Sample input and output.

Table-1:  Actual Values

CATYEARJANFEBMARAPRMAYJUNEJULAUG
A2021100120150200300250400200
B2021120300120130250500100600

 

Table-2: Forecast Values

CATYEARJULAUGSEPOCTNOV
A2021100150200300250
B2021200150400300350

 

Expected Output:

CATACTUAL YTD90 DAY FORECAST
A1720750
B21201050

 

Please help me to do.

Thanks,

AshDil

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hi @Ashish_Mathur ,

It worked for me. Thanks for your help.

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.