Forum Discussion

SeanN87's avatar
SeanN87
Frequent Visitor
5 years ago
Solved

Taking First value from duplicates in a column

I'm trying to create a dimension table that has Part Numbers and a corresponding Part Description. I successfully created the table with one column of Part Numbers (because those are unique), but dep...
  • daxer-almighty's avatar
    daxer-almighty
    5 years ago

     

    [Parts] =
FILTER(
    ADDCOLUMNS(
        DISTINCT( T[Part_Number] ),
        "Description",
            FIRSTNONBLANK( T[Part_Description], 1 )
    ),
    NOT ISBLANK( T[Part_Number] )
)

     

daxer-almighty's avatar
daxer-almighty
Icon for Solution Sage rankSolution Sage
5 years ago

 

[Parts] =
FILTER(
    ADDCOLUMNS(
        DISTINCT( T[Part_Number] ),
        "Description",
            FIRSTNONBLANK( T[Part_Description], 1 )
    ),
    NOT ISBLANK( T[Part_Number] )
)

 

SeanN87's avatar
SeanN87
Frequent Visitor
5 years ago

Perfect! Thank you so much for the quick response.