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.
I have a query including a case statement(copied below) that run in SQL Server 2012 and I just took it into Power BI.
My slicer visual (Join Date Range) equals the Case statement from SQL Server:
case
when mbr_join_date>=getdate()-7 then 'Last Week'
when mbr_join_date>=getdate()-30 then 'Last Month'
when mbr_join_date>=getdate()-60 then 'Last 60 Days'
when mbr_join_date>=getdate()-90 then 'Last 90 Days'
else 'Last Fiscal Year'
A little bit about data: People are basically joining an organization and as of now the slicer works as a case statament meaning once I choose 'Last Week' Joins I get person A,B and C, however, when I choose 'Last Month' I would expect person A.B,C to be included in the result set but they are not. I know it is because my sql case statement eliminates those.
Can you please advice how can I accomplish person A,B, and C appear in both, 'Last Week' and 'Last Month' and basically in other options too?
It doesn't matter if the solution is in SQL or power bi as long as it works.
Thank you.
Solved! Go to Solution.
Based on your requirements, you could use the relative date slicer.
Based on your requirements, you could use the relative date slicer.
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |