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 Community,
Thank you Vanessa for helping with the % Lifts.
I am trying to develop a measure in which the sale price for a specific week is X cheaper than the non-promo price. I would like the non-promo price to stay static. So when a week on the bar graph is selected, it doesn't change and the formula for computing the difference in promo vs. non promo price.
Price difference = [promo price] - [non-promo price]
Other formulas that may impact:
The second picture, I also edited the card hoping that it would keep that value when doing the price difference calculation. I have tried to use var calc, All, allexcept, filters on the price measures and the difference, but nothing changes.
I am guessing the calculation is more complicated that I thought - maybe requires multiple measures aside from what I have already. Var calc or AverageX can solve it? Any thoughts? Thank you in advance.
Hi @Anonymous ,
Price difference =CALCULATE( [promo price] - [non-promo price],ALL('Table'))
Better to provide more details about your table and your problem or share me with your pbix file after removing sensitive data to help us clarify your scenario.
Best Regards,
Eyelyn Qin
Hi Eyelin,
Thank you for your answer. I did that before - with adding the column (promotion). I left it in there so you can take a look.
Here is a link to the file.
https://www.dropbox.com/s/3pbcp6iw3upr3m4/Lowes%202021%20Fiscal%20Year%20-%20Version%204.4.pbix?dl=0
Hope this helps - thanks for looking into it.
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 |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |