Filter values based on next days

[rosscortb]

Hello 

I have two date colums Air Departure Date and Hotel Check Inn date and I want a filter that show the next 3 days.

I know you can add the slicer and do relative date and choose next(number of days) but you can only do that one one date value while I have two. Any ideas? Ross

[v-yiruan-msft]

Hi @rosscortb ,

Could you please provide some sample data (exclude sensitive data) and your expected result with screenshot? Thank you.

Best Regards

Rena

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[TomMartens]

Hey @rosscortb ,

I'm not 100% sure if I understand your requirements.

Nevertheless, from what I understand (at least guess to understand) I recommend the following.

Create a separate calendar table, that is not related to your existing table from the screenshot below. Use this calendar table with a slicer.

Based on the slicer selection create a measure that flags the rows that are matching the conditions (return 1 if the conditions are matched otherwise return 0), you can then use this measure inside a visual level filter to show the matching rows.

If you need more assistance, please create a pbix with sample data, but still reflects your data model, upload the file to onedrive or dropbox and share the link.

Regards,

Tom