Solved: Filtering in Power Query

Anonymous · ‎03-15-2023

Hi,

I have table like below,

yyyy-mm	count1	count2
2023-03	10	20
2023-02	10	30
2023-01	20	40

I want to filter the table in the power query for current year and the month ie 2023-03. How do i do it?

Please help

@Ashish_Mathur

Thanks

KNP · ‎03-15-2023

See attached PBIX.

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.

Proud to be a Super User!

View solution in original post

Ashish_Mathur · ‎03-15-2023

Hi,

Why do you want to filter in the Query Editor? By applying a filter here, the unfiltered rows will not lead in the Data Model at all. Could you share the objective you are trying to achieve?

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

KNP · ‎03-15-2023

See attached PBIX.

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.

Proud to be a Super User!