Forum Discussion

hewgreen's avatar
hewgreen
New Member
1 year ago
Solved

Removing duplicates with merging logic

I'm struggling to combine functions correctly (such as FILTER and DISTINCT) in a CALCULATETABLE query. I used the following to generate a slice of a larger input table based on the Product string: ...
  • Deku's avatar
    Deku
    1 year ago

    Addcolumns(

    Distinct( tbl[customer]),

    "Instances",

    calculate( concatenatex( values(tbl[instance]), tbl[instance], ", ")),

    "Quantity",

    Var sumQuanity = CALCULATE( sum(tbl[quantity] ))

    Var minQuantity = calculate( min( tbl[quantity] ))

    Return

    If( minQuanity = -1, minQuanity, sumQuantity)

    )

Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
1 year ago

Hi, hewgreen 

From screenshot you provided it don't seems like duplicate, because it has two instance (0001,0002) and customer(Bob) has value for both instance.

Please provide some sample row data to understand better your problem

Best Regards,
Dangar

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • hewgreen's avatar
    hewgreen
    New Member
    1 year ago

    I've used the term duplicate incorrectly. Within the scope of Customer 'Bob' is duplicated. Therefore I'd like the merge these rows.