Forum Discussion

DeoYadav's avatar
DeoYadav
Regular Visitor
4 years ago
Solved

Calculated table using DAX

How to get the result as below.   EMP_table      Department_table   Result Table EmpId Name DepName 1 Raj IT 2 Kishor HR 2 Abhi FR 4 Kiran No Department ...
DAX
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi DeoYadav,

     

    I use selectedcolumns() to do this.

     

    Result Table =
SELECTCOLUMNS (
    'EMP_table',
    "empid", [new EmpID],
    "name", [Name],
    "DepName",
        IF (
            ISBLANK ( RELATED ( Department_table[DepName] ) ),
            "No Department",
            RELATED ( Department_table[DepName] )
        )
)

     

     

    Result:

     


    Pbix in the end you can refer.

    Best Regards

    Community Support Team _ chenwu zhu

     

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

v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi DeoYadav ,

 

Can you explain why the second and third rows are the same Empid 2?

 

If you want get the depName from Department_table, a relationship between these two tables on DepID is needed. Then create the new column in EMP_table via related(Department_table[DepName])

 

Best Regards

Community Support Team _ chenwu zhu

 

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

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi v-chenwuz-msft , "Can you explain why the second and third rows are the same Empid 2?" - this is the result that I want in a calculated table.

     

    • v-chenwuz-msft's avatar
      v-chenwuz-msft
      Community Support
      4 years ago

      Hi DeoYadav,

       

      I use selectedcolumns() to do this.

       

      Result Table =
SELECTCOLUMNS (
    'EMP_table',
    "empid", [new EmpID],
    "name", [Name],
    "DepName",
        IF (
            ISBLANK ( RELATED ( Department_table[DepName] ) ),
            "No Department",
            RELATED ( Department_table[DepName] )
        )
)

       

       

      Result:

       


      Pbix in the end you can refer.

      Best Regards

      Community Support Team _ chenwu zhu

       

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