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
OwenAuger Super Contributor
Super Contributor

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
OwenAuger Super Contributor
Super Contributor

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!




Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 43 members 955 guests
Please welcome our newest community members: