Forum Discussion

febrina's avatar
febrina
New Member
4 years ago
Solved

Filter rows based on two columns

Hi, I want to exclude my data based on two conditions. 1. Column [Name] = "Sarah" 2. Column [Date] = Less than 09/01/2021   Does anyone know how to make the filter? I have tried to add custom co...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    4 years ago

    Hi, febrina 

     

    You can create a column and use it in filter pane to filter data.

    Like this:

    column =
IF ( table[Name] = "Sarah" && table[Date] <= DATE ( 2021, 9, 1 ), 1, 0 )

    Did I answer your question? Please mark my reply as solution. Thank you very much.
    If not, please feel free to ask me.
     
    Best Regards,
    Community Support Team _ Janey
v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, febrina 

 

You can create a column and use it in filter pane to filter data.

Like this:

column =
IF ( table[Name] = "Sarah" && table[Date] <= DATE ( 2021, 9, 1 ), 1, 0 )

Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
 
Best Regards,
Community Support Team _ Janey