Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 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.
Solved! Go to Solution.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.