What-if scenario on Date

immkhan · ‎05-27-2020

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