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.
Hello,
I have an interesting one today.
I have a column with 5 products. My Table shows these products with the associated revenue and the total at the bottom.
I am hoping to use 5 what if parameters to create a what-if product mix table. So if I were to set each what-if parameter to 20%, the total revenue from my first table would be reallocataed in a 2nd table.
Table 2 below is the expected result based on the parameters. I am having a hard time figuring out what the [New Revenue Measure] should be.
Table 1 Paramters Table 2:
Product Revenue A 20% Product New Revenue Measure
A 100 B 20% A 200
B 100 C 20% B 200
C 250 D 20% C 200
D 250 E 20% D 200
E 300 E 200
Total 1,000 Total 1,000
Appreciate any help!! Thank you!
Assume what if measure is a parameter and 20 is the absolute selected value
Measure = Table1[Revenue]* (1+(max(Paramters[ParamtersMeausre])/100))
Hello,
What if different % are given to different products to see the revenue projection?
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 |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |