Forum Discussion

Sam7's avatar
Sam7
Icon for Advocate II rankAdvocate II
2 years ago
Solved

How to filter out dates in the middle?

Hiya,    I have a set of data, with dates from yesterday to the past.  I want to exclude the the day before yesterday and 9 days after this, so filter out this middle 10 days?  How do I action this...
Need Help
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    Hi Sam7 

    Please write a Calculated Column with DAX function like 
    Today date is 18.10.2023, so I made range of date as False

     

     

    Column = SWITCH(
    TRUE(),
    'Table'[Date] = TODAY()-1,"False",
    'Table'[Date] > TODAY()-11,"False",
    "True")

     

     

    Then filter out your VIsual or Page with True or False value

    You can write similar code in M Power Query

    If solve your requirement, please mark as SOLUTION and give LIKE

PijushRoy's avatar
PijushRoy
Icon for Community Champion rankCommunity Champion
2 years ago

Hi Sam7 

Please write a Calculated Column with DAX function like 
Today date is 18.10.2023, so I made range of date as False

 

 

Column = SWITCH(
    TRUE(),
    'Table'[Date] = TODAY()-1,"False",
    'Table'[Date] > TODAY()-11,"False",
    "True")

 

 

Then filter out your VIsual or Page with True or False value

You can write similar code in M Power Query

If solve your requirement, please mark as SOLUTION and give LIKE