Forum Discussion
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. Plea...
see my videohttps://1drv.ms/v/s!AiUZ0Ws7G26Rh3ErTgr710-MAzvV?e=L50uvi
Sample PBIX file attached
https://1drv.ms/u/s!AiUZ0Ws7G26Rh3CTPlsBn409Ozfo?e=pKtsW4= Table.SelectRows( from, (x)=> not List.ContainsAny( Record.FieldValues(x),{"USA","Mexico"},Comparer.OrdinalIgnoreCase) and x[Date] = #date(2023, 5, 2))
Thank you so much for your time.
Due to other limitations, we want to achive same in query editor. Please let me know how to achive
Ahmedx
Super User
Super User
see my video
https://1drv.ms/v/s!AiUZ0Ws7G26Rh3ErTgr710-MAzvV?e=L50uvi
Sample PBIX file attached
https://1drv.ms/u/s!AiUZ0Ws7G26Rh3CTPlsBn409Ozfo?e=pKtsW4
= Table.SelectRows( from,
(x)=> not List.ContainsAny( Record.FieldValues(x),{"USA","Mexico"},Comparer.OrdinalIgnoreCase) and
x[Date] = #date(2023, 5, 2))
Thank you so much. it works