Forum Discussion

niteshtrehan89's avatar
niteshtrehan89
Helper III
5 years ago

calculated column

Hi All,    Hope everyone is doing good. I need to write a calculated column which will give us the detail either the employee is working in samedept or differentdept. below is the dataset Emp...
Need Help
Fowmy's avatar
Fowmy
Super User
5 years ago

niteshtrehan89 

There was no mention about Department Status, I believe you need to check based on the employee id and the department status, please use the following modified code:

Dep Status =
VAR __emp = Table15[Employee ID],
VAR __status = Table15[Dep_Status]
VAR __dep =
    LEFT ( Table15[Department ], 1 )
RETURN
    IF (
        SUMX (
            FILTER ( Table15, Table15[Employee ID] = __emp && Table15[Dep_Status] = __status ),
            INT ( LEFT ( Table15[Department ], 1 ) <> __dep )
        ) = 0,
        "Same Department",
        "Different Department"
    )

 

niteshtrehan89's avatar
niteshtrehan89
Helper III
5 years ago

Hi Fowmy 

Still not working. Infact the slicer department status is nothing but the same department and different department.

Same department= intercompany 

Different department= Non-intercompany

 

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    5 years ago

    Hi. niteshtrehan89 

    Can you show your current adjusted code formula?

     

    Best Regards,
    Community Support Team _ Eason