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?
Go to Solution.
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)
Proud to be a Datanaut!
Power BI Super User, Greg Deckler, explains
Register by September 5 to save $200
Engage and empower students with Power BI!
Continue your learning in our online communities.