Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Apply Filter from specific date

Hi All,

 

I have last 30 days data with columns Region, etc. Requirement is to apply filter like Region does not contain USA and Mexico from specific date like 20/04/20203. How to achive this. Please suggest

 

Regards,

Suren

Need Help

7 Replies

  • Ahmedx's avatar
    Ahmedx
    Super User
    3 years ago

    pls try this

    Measure = CALCULATE(
                CALCULATE(SUM('Table'[Value]), 
                    KEEPFILTERS( NOT'Table'[Region] in {"USA","Mexico"}),
                      KEEPFILTERS( 'Table'[Business Days]= DATEVALUE("5/2/2023") ) 
))

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thank you so much for your time. Please let me know how to achive same in query editor 

  • Ahmedx's avatar
    Ahmedx
    Super User
    3 years ago

    or

    = Table.SelectRows( from,
      (x)=> not List.ContainsAny( {x[Region]},{"USA","Mexico"},Comparer.OrdinalIgnoreCase) and 
       x[Date] = #date(2023, 5, 2))