Forum Discussion

smjzahid's avatar
smjzahid
Icon for Helper V rankHelper V
6 years ago
Solved

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.     I want to apply a step in my power query that woul...
Need Help
Show and Tell
  • camargos88's avatar
    camargos88
    6 years ago

    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.

     

camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
6 years ago

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.