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
Malle
Frequent Visitor

Calculate YTD for Actual and Full-year for Forecast - depending on chosen value

Hey! 
I have trouble trying to calculate the following:

I have different values with dates connected to them (Actual, Plan, Forecast).
Users want to be able to compare YTD values for the Actual with Full-year values for Forecast and Plan.


For example: Users want to see YTD Month 1-3 Actual vs Full-year Forecast but not the YTD 1-3 Forecast.

Is that possible to achieve in a measure?
Atm I have a YTD Measure and a Full-year value measure. I kinda want to combine them into one, with different calculation depending of the chosen type of value.

I want these two value to be in the same column:

Malle_0-1634279201137.png

 

1 ACCEPTED SOLUTION
v-yalanwu-msft
Community Support
Community Support

Hi, @Malle ;

You could enter a table ,then create a measure as follows:

1.enter table

vyalanwumsft_0-1634606177965.png

2.create a measure.

Measure = SWITCH(MAX([Prozess]),"lst",[Measure1],"FC3",[Measure2])

The final output is shown below:

vyalanwumsft_1-1634606251561.png

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yalanwu-msft
Community Support
Community Support

Hi, @Malle ;

You could enter a table ,then create a measure as follows:

1.enter table

vyalanwumsft_0-1634606177965.png

2.create a measure.

Measure = SWITCH(MAX([Prozess]),"lst",[Measure1],"FC3",[Measure2])

The final output is shown below:

vyalanwumsft_1-1634606251561.png

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@Malle , Refer my blog, where I have explained how can you use yearly value as daily or monthly and YTD

 

Distributing/Allocating the Yearly Target(Convert to Daily Target): Measure ( Daily/YTD): Magic of CLOSINGBALANCEYEAR With TOTALYTD/DATESYTD: https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Yearly-Target-C...

 

Distributing/Allocating the Yearly Target(Convert to Daily Target): https://community.powerbi.com/t5/Community-Blog/Distributing-Allocating-the-Yearly-Target-Convert-to...

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.