Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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