Column name

[unnijoy]

Hi I have a Data base with Agent name and their Level. Now i need to get a dax which will look in each column and give me the name of the column in which the agent name is present.

Name	Level	L1	L2	L3	L4
Max	L3	Rex	Lux	Max	Sam
Sam	L2	Max	Sam	Chris	Hex

So i need to create this calulated column "Level" next to each Agent in Bi. We can see that max name is coming under L4 so i need L4 in Level column next to max. If the name is not present then i need blank. I need to achive this by Dax. 

How can we do this.

[v-cgao-msft · Accepted solution]

Hi @unnijoy ,

Please try this:

Level = 
SWITCH(
    TRUE(),
    'Table'[L1]='Table'[Name],"L1",
    'Table'[L2]='Table'[Name],"L2",
    'Table'[L3]='Table'[Name],"L3",
    'Table'[L4]='Table'[Name],"L4"
)

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[Anonymous]

@unnijoy can you provide few more example of the data with the output you are looking for.

[unnijoy]

Above is the structure of ma table. Only thing i add extra is the Level Column.  In Name column i will have the name of the employe. The employee name will be in any one column from L1 - L4. So what i need to get the the column name under which the employee name is coming. In the above we can see that Max name is coming under L3 so i need to get L3 in Level Column. In excel we use to do this with Inded Match. But not sure how to do it in PowerBi.