Forum Discussion

dgenatossio's avatar
dgenatossio
Frequent Visitor
8 years ago
Solved

Unique column values

I have read through dozens of posts and haven't found a post with an answer for the problem I'm encountering.   I have two data tables. One has Plan for the Year. The other has Results. I want to c...
  • Eric_Zhang's avatar
    Eric_Zhang
    8 years ago

    dgenatossio

    One way through DAX. Create the employee list as below. If it is not your case, please post some sample data and expected output.

    employees =
DISTINCT (
    UNION (
        SELECTCOLUMNS ( plan, "empid", plan[Employee ID] ),
        SELECTCOLUMNS ( result, "empid2", result[Employee ID] )
    )
)

Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

dgenatossio

One way through DAX. Create the employee list as below. If it is not your case, please post some sample data and expected output.

employees =
DISTINCT (
    UNION (
        SELECTCOLUMNS ( plan, "empid", plan[Employee ID] ),
        SELECTCOLUMNS ( result, "empid2", result[Employee ID] )
    )
)