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.
Hi Experts,
There is a table containing coulmns like Date and Revenue.
Now I need to create two differnet date Slicers from the "Date" column as below:
Slicer1:Current Date Range
Slicer2:Previous Date Range
Based on the Dates selected in the date Slicer, I should have 2 different calculations for Revenue as below:
Current Revenue:to show the revenue based on date seleted in "Slicer1"
Previous Revenue:to show the revenue based on date seleted in "Slicer2"
Please refer the example as below:
Suppose there is a table visualization having columns"Current Reveune"and "Previous Revenue".
Suppose, I selected 1-7 Jan2024 in Slicer 1 and 24-28 Dec2023 in Slicer2 then "Current Revenue" column in table visualization above will show the revenue from 1-7Jan2024 and "Previous Revenue" column will show the revenue from 24-28Dec2023.
Is such scenario achievable in power bi.
Please help.
Solved! Go to Solution.
I suggest following the method shown here on DAX Patterns:
https://www.daxpatterns.com/comparing-different-time-periods/
This method involves creating a copy of your 'Date' table, called 'Comparison Date' in the article, which has an inactive relationship with 'Date'. Then "comparison" measures can be created that activate this relationship and remove filters on the original 'Date' table.
The DAX Patterns article also covers adjusting the comparison measures to correct for different numbers of dates, but you may not need to do that.
Please post back if needed 🙂
Regards
I suggest following the method shown here on DAX Patterns:
https://www.daxpatterns.com/comparing-different-time-periods/
This method involves creating a copy of your 'Date' table, called 'Comparison Date' in the article, which has an inactive relationship with 'Date'. Then "comparison" measures can be created that activate this relationship and remove filters on the original 'Date' table.
The DAX Patterns article also covers adjusting the comparison measures to correct for different numbers of dates, but you may not need to do that.
Please post back if needed 🙂
Regards
Thanks a lot for your help Owen. I was looking for the same. 🙂
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 |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
188 | |
111 | |
105 | |
78 | |
71 |