Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
Hope someone can help me here.
How in power query I can achieve the below record as a single record.
i have approximately 20k records and many of them have below scenarios.. 2-3 records of per user ID's
I am after the below output.
Thank you
Solved! Go to Solution.
Do a 'Group By' on the first 3 fields and add aggregations(MAX) for each of the other fields.
That should do it
Do a 'Group By' on the first 3 fields and add aggregations(MAX) for each of the other fields.
That should do it