Forum Discussion

Raj3798's avatar
Raj3798
Frequent Visitor
2 years ago
Solved

Removing duplicates from column2 based on column 1

Hi ,  Attached the data below, I want to remove the duplicates and have the desired output. All my data is from the same  table. Stack Order Report No 1 1110 1 1111 1 1112 ...
DAX
  • vicky_'s avatar
    vicky_
    2 years ago

    Please try the following DAX: 

    SummaryTable = ADDCOLUMN(VALUES(Table[Stack Order]), "First Report No", CALCULATE(MIN(Table[Report No])))

    But the same result can also be acheived in PowerQuery, where you can go to Transform > Group By, and group by the Stack Order and Aggregate by the min Report Number

     

vicky_'s avatar
vicky_
Icon for Super User rankSuper User
2 years ago

Please try the following DAX: 

SummaryTable = ADDCOLUMN(VALUES(Table[Stack Order]), "First Report No", CALCULATE(MIN(Table[Report No])))

But the same result can also be acheived in PowerQuery, where you can go to Transform > Group By, and group by the Stack Order and Aggregate by the min Report Number