Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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. 🙂
User | Count |
---|---|
106 | |
86 | |
81 | |
73 | |
72 |
User | Count |
---|---|
112 | |
100 | |
98 | |
72 | |
66 |