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'm looking for the way to eliminate a bit more complex duplicates. The rule would be something along those lines: If: the same job category, same date and postcode, then deduplicate entry which has lower or same calculated value (Open=1, Booked=2, Closed=3). If same deduplicate on later entry. Column with calculated value has been already created. But does anyone know how to create that deduplication query? Many thanks in Advance!
According to your description, you want to keep the row with biggest value within category, date, and postcode group. Right?
In this scenario, you just need to use SUMMARIZE to aggregate entries on category, date and postcode level.
Calculated Table = SUMMARIZE ( Table, Table[category], Table[date], Table[postcode], "Status", MAX ( Table[Status Code] ) )
Regards,
Hi Simon,
Sorry for a late reply.
That part worked! But I need other columns too in the table, unless I can somhow link it back to the Orginal table, which contains Job ID, booked.
Also Is there a fast way of exportingtoa CV with such calcualted table to check if everything worked properly?
Many Thanks
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |