Date Filter Issue

[83dons]

I have imported several tables from SQL Server database and created a reference table to one of them which I am not filtering as required. I need the date column to only show dates that are TODAY+2 days. Excel and Access etc all allow this to be done but I cant find any option in the date filters on the table to allow me to do this in power BI desktop. I have tried every combination I can see. Can I apply a coding filter somehow to get round this?

eg today is 08/05/2022 and I want to only see rows where date column = 10/05/2022 (ie TODAY + 2 days).

Or do I need to filter the date on that table when I import it in the first place from SQL Server. I was trying to avoid using a SQL statement to import tables to avoid complexity though.

Any help appreciated.

[mahenkj2 · Accepted solution]

Hello @83dons ,

You can create a conditional column and use as a filter to remove all non confirming rows or use on the page or visual filters:

You can add a custom column to check if date column date is today +2 days?:

I attach a sample file:

https://drive.google.com/drive/folders/1AcTszqN1Y7VaAlRjHsmZTN8fftAtIOSG?usp=sharing

[83dons]

Thanks that worked.