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?

 

Cheers

 

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

3 Replies

  • 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Sam7 ,

     

    You can create a custom column to filter.

    =if [Date]>=Date.AddDays(DateTime.Date(DateTime.LocalNow()),-2) and [Date]<=Date.AddDays(DateTime.Date(DateTime.LocalNow()),7) then 1 else 0

    Filter out 1, filter the middle 10 days.

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.