Filter from multiple columns

[dshah12]

I have this kind of table and I want to apply specific condition for program name ="abc" that if should have just the data of 2023 from "created on" but the rest of data should remain intact 

program name	created on	short name
xyz	2023	d
abc	2022	sx
abc	2023	rf
wed	2022	f

[BA_Pete · Accepted solution]

Hi @dshah12 ,

Filter your table on anything, just to get the Table.SelectRows code populated in your formula bar. For example:

Now edit the code directly in the formula bar to this:

Pete

[dshah12]

Thanks a lot for quick response but when I apply to similar other I donot get any data

= Table.SelectRows(#"Changed Type", each not ([Program Short Name] ="IF" and DateTime.Date([Created On])< #date(2022, 9, 1)))

[BA_Pete]

Hi @dshah12 ,

The principle should work the same.

Is this the correct reference for your previous query step?

If that's not the issue, then you may need to provide some more example data that represents this new scenario.

Pete

[ManuelVasquez97]

Good morning!

I watch that in your Created in column, only the year appears, but in the condition that you enter it is as a date. Could that be the mistake?

[dshah12]

The condition I applied to different table which was similar here I wanted all IF programs after 1 Sep 2022