Load Latest Dates records in Power BI Query Editor

[Anonymous]

Hi,

I am new to Power BI. I have connected to Sql server and loading tables in Power BI to get the data.

I have data for all previous snapshot dates. from last 1 Quarter. I just want to load latest date records in my Power BI.

Currently, in Advance editor, I have written below script which is working fine. But I don't want to hardcode the value as in next load Max date will be different as we load data on every Friday.

    #"Filtered Rows" = Table.SelectRows(#"Removed Columns", each [Load_Creation_Date] = #date(2018, 11, 23)),

I tried something like below:

    #"Filtered Rows" = Table.SelectRows(#"Removed Columns", each [Load_Creation_Date] = Max(Load_Creation_Date))

but it's not working. Can anyone please help me?

Thanks!

Regards,

Poonam

[OwenAuger · Accepted solution]

Hi Poonam

You can use the Power Query interface to filter on the latest Load_Creation_Date.

In the Power Query editor, click the dropdown on the Load_Creaton_Date column => Date Filters => Is Latest.

This should generate code looking like:

#"Filtered Rows" = Table.SelectRows(#"Removed Columns", let latest = List.Max(#"Removed Columns"[Load_Creation_Date]) in each [Load_Creation_Date] = latest)

Regards,

Owen