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.
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
Solved! Go to 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
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
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.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |