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.
I'm new in Power Query Excel. I'm trying to update value in the column 3 based on unique value created by combining two columns ID 1 and ID 2.
If the unique value is duplicated, value in column 3 will be updated referenced by the latest Date created.
Here is my data.
In this table, Data in No 1 and 7 with duplicated when combine ID 1 and ID 2.
My expected result: Data in Column 3 of the oldest record is updated by the latest data in Column 3
Solved! Go to Solution.
Hi @Anonymous
group your table on columns "ID1" and "ID2" with 2 aggregations: MAX on column "Date created" and "All" (no column selection for that)
Then expand the resulting "All"-column with all but the "Date created" column (because this column is already there with the latest date of the combination).
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Hi @Anonymous
group your table on columns "ID1" and "ID2" with 2 aggregations: MAX on column "Date created" and "All" (no column selection for that)
Then expand the resulting "All"-column with all but the "Date created" column (because this column is already there with the latest date of the combination).
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
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.