Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Solved! Go to Solution.
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.
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.
@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...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |