Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Good Afternoon,
Is there an easy way using the filters pane to filter visuals on or before today's date?
I can't seem to see this as an option which seems a bit odd unless I'm missing it!
Thanks
Solved! Go to Solution.
If you have a calendar table, you can create an offset column which returns -1 if it's before today's date or 0 otherwise. Then, you can use filter pane to filter by <0 values
Offset = IF('Calendar'[Dates]<=TODAY(),-1,0)
Hi,
You could created a field in power query that flags all dates from today and use that on in the filter pane:
Power query column: if [Date] >= Date.From(DateTime.LocalNow()) then 1 else 0
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Hi,
You could created a field in power query that flags all dates from today and use that on in the filter pane:
Power query column: if [Date] >= Date.From(DateTime.LocalNow()) then 1 else 0
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
If you have a calendar table, you can create an offset column which returns -1 if it's before today's date or 0 otherwise. Then, you can use filter pane to filter by <0 values
Offset = IF('Calendar'[Dates]<=TODAY(),-1,0)
User | Count |
---|---|
107 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |