cancel
Showing results for
Did you mean:

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

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:

1 ACCEPTED SOLUTION
Community Support

Hi, @Malle ;

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

1.enter table

2.create a measure.

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

The final output is shown below:

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.

2 REPLIES 2
Community Support

Hi, @Malle ;

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

1.enter table

2.create a measure.

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

The final output is shown below:

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.

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...