How to filter dates 2 days before today

1
votes

Table has a column with dates. I am showing this data with Table visualization. I need to filter the date to always show dates that are 2 days before from now. For example today is 22.04.2020 and I need to filter it so it would automatically show only data with dates 2 days before like 20.04.2020 as a max date. In SQL I use codeDATEADD(DAY, -1, @today)
Since I'm using direct query then I can't make changes to the date table in query manager ( It needs to be updated every 15 minutes )

How can I do that in Power BI visualization?

1
powerbipowerquery

1 Answers

0
votes

Very simple, use relative filtering.
You can define it as a slicer, a hidden slicer or in the filter panel.