cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
smjzahid
Helper IV
Helper IV

How to filter to latest period in Power Query

I have a column in my table  Programme called Period No. of type Whole Number, this contains 13 different period in a year. for eg.

 

Programme.JPG

 



I want to apply a step in my power query that would only filter the data for the maximum period in the table, as in the below example as of now I only want period 202002 to filter and load, (as this is the latest period) 

In the next month I want it to filter for period 202003 and so on (meaning only pick up the maximum period from the column. How do I achieve this in Power Query.

 
1 ACCEPTED SOLUTION
camargos88
Community Champion
Community Champion

Hi @smjzahid ,

 

Try this code for a custom column and filter the result:

 

if [Column1] = List.Max(#"Changed Type"[Column1]) then 1
else 0

 

Change the bold part with your last step name.

 

Capture.PNG



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



View solution in original post

1 REPLY 1
camargos88
Community Champion
Community Champion

Hi @smjzahid ,

 

Try this code for a custom column and filter the result:

 

if [Column1] = List.Max(#"Changed Type"[Column1]) then 1
else 0

 

Change the bold part with your last step name.

 

Capture.PNG



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!