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 everyone ! 🙂
I'm working on a specific report where we want to compare price variation between selection from two date slicers. 🤑
The datamodel is the following :
I have my Calendar table, and a second one with a Inactive relationship (used for the Last_Price measure).
The data samples from the tables are :
PRICE Table :
CALENDAR and COMPARE_DATE table :
The report I want to build is similar as this one. We select the two weeks to compare and I want to find the %PriceChage for the TOTO Brand (but the actual result is not the one i need) :
The problem is simple, I would like to have the average on the data that can be compared.
Instead of having the variation on the average of "Actual Price" and "Last Price" for all the references, I need to have the average for the A reference only. It is the only reference where we can find an actual price and a last price value.
So the number I want to have as the %Price Change for TOTO is ((6+10)/2 - ((5+5)/2) / ((5+5)/2) = 60%
The measures used are :
If you find answer to my problem I will be very grateful to you. Thanking you. 🤗
I am not even sure that it is necessary to have a second calendar table.
BR,
Kilian
Solved! Go to Solution.
@KilianM , refer to my blog or video on how to deal with two slicers
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
or
https://www.youtube.com/watch?v=WSeZr_-MiTg
Hello @amitchandak,
Thank you for your answer.
My problem is how to compare only the references with prices in the two contexts.
Do you know how to deal with this problematic ?
Thank you,
Best regards,
KM
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 |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |