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.
Hi,
I have to apply the What-if scenario on Date but unable to do so. My data is like: (All are data and calculated columns; no Measures)
Product Lot Total_Shelf_Life Rem_Shelf_Life Rem_Shelf_Life% Rem_Shelf_Life_Bracket Quantity
Item A 12 24 (months) 13 54 % 50% - 75% 30
Item A 21 36 (months) 10 28 % 25% - 50% 20
Item A 123 24 (months) 5 21 % Below 25% 10
Item A 112 24 (months) 15 63 % 50% - 75% 40
Item A 142 24 (months) 18 75 % 50% - 75% 50
Now I have created a line chart graph in which "Rem_Shelf_Life_Bracket" is on Axis and Quantity is on Values. The graph plotted fine. Example is like :
Consider values as following for Brackets:
Below 25% = 10
25% - 50% = 20
50% - 75% = 120
Now I want to create a What-if Scenario for Rem Shelf Life. User wants to see where the values will be if the Remaining Shelf Life decreases by a Month or Two.
For that, I created Adjusted Month Parameter in which user will mention the values from -1 to -12. Now the problem is how can i calculate the measure and change the values in Rem_Shelf_Life_Bracket.
Example: If user select Adjusted month as "-2" then another line should appear with values
Below 25% = 30
25% - 50% = 70
50% - 75% = 50
Please help me out how can I do it.
Regards
Hello @immkhan
What is the logic of Shelf Life % calculation?
Cheers!
Vivek
https://www.vivran.in/
Connect on LinkedIn
Hi
Remaining Shelf Life / Total Shelf Life
Regards
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 |
---|---|
47 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
76 | |
50 | |
46 | |
16 | |
12 |