cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Load Latest Dates records in Power BI Query Editor

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Load Latest Dates records in Power BI Query Editor

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



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

Proud to be a Datanaut!




1 REPLY 1
Highlighted
Super User
Super User

Re: Load Latest Dates records in Power BI Query Editor

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



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

Proud to be a Datanaut!