Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
90 | |
82 | |
62 | |
61 | |
58 |
User | Count |
---|---|
159 | |
114 | |
100 | |
75 | |
65 |