Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am trying to create a date filter that filters data like this (Finish_Date >= value selected), meaning that if a user selected today's date, they will get a results for today's date and beyond , it will look ahead. Additionally the second filter should do the opposite, when the user select todays date, they get the data for today and all the previous days (Start_Date <= value selected). Does anyone know how to create such a filter?
Solved! Go to Solution.
Hi, @Anonymous
You can try the following methods.
Sample data:
Create a new date table.
Date = CALENDARAUTO()
Measure:
Measure1 = IF(SELECTEDVALUE('Table'[Date])>=SELECTEDVALUE('Date'[Date]),1,0)
Measure2 = IF(SELECTEDVALUE('Table'[Date])<=SELECTEDVALUE('Date'[Date]),1,0)
Put measure separately in the filter of the corresponding view and set equal to 1.
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Anonymous
You can try the following methods.
Sample data:
Create a new date table.
Date = CALENDARAUTO()
Measure:
Measure1 = IF(SELECTEDVALUE('Table'[Date])>=SELECTEDVALUE('Date'[Date]),1,0)
Measure2 = IF(SELECTEDVALUE('Table'[Date])<=SELECTEDVALUE('Date'[Date]),1,0)
Put measure separately in the filter of the corresponding view and set equal to 1.
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I needed to be able to use this new column as a date filter in the report builder but the results you are showing are in Power BI, would you be kind enoughto point me to the workaround on this?
Check this and see if it can be fit to your requirement
https://radacad.com/power-bi-from-and-to-date-filtering-with-one-slicer
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |