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 all...
I created a What If parameter and named it "% Price Change." It created the below table and measure:
Solved! Go to Solution.
Hi and thank you. I think I figured it out. This code looks to be working:
Revenue after % Price Change =
SUMX('Item Sales','Item Sales'[Net Sales])
+ SUMX('Item Sales','Item Sales'[Qty] * 'Item Sales'[Price]
* '% Price Change'[% Price Change Value]/100)
Date Item Qty Gross Sales Discounts Net Sales Unit Price
7/20/2019 1 9 $45.00 ($9.00) $36.00 ea $5.00
9/21/2019 2 8 $40.00 ($8.00) $32.00 ea $5.00
Hi @bchager6 ,
Can you please share some sample data and expected the result for test? It will help us clarify your scenario.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Hi and thank you. I think I figured it out. This code looks to be working:
Revenue after % Price Change =
SUMX('Item Sales','Item Sales'[Net Sales])
+ SUMX('Item Sales','Item Sales'[Qty] * 'Item Sales'[Price]
* '% Price Change'[% Price Change Value]/100)
Date Item Qty Gross Sales Discounts Net Sales Unit Price
7/20/2019 1 9 $45.00 ($9.00) $36.00 ea $5.00
9/21/2019 2 8 $40.00 ($8.00) $32.00 ea $5.00
I think your measure is not correct. It should be
Thank you. I tried that as well and while it brings me closer, it's still a few hundred dollars off. I may be overthinking things, but I tested the measure results by going in to the source data, changing the prices by 10%, and then multiplying the new prices by the quantitites instead of just multiplying Net Sales by 10%.
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 |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |