Forum Discussion
Helper IIFilter a visual on or before today's date
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
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 👍
4 Replies
- DOLEARY85
Resident Rockstar
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 👍
pigsinblanketsThank you DOLEARY85 🙂
mlsx4Memorable Member
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)- pigsinblankets
Ahh thank you mlsx4 🙂