Forum Discussion

unnijoy's avatar
unnijoy
Post Prodigy
4 years ago
Solved

Column name

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 L...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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's avatar
Anonymous
Not applicable
4 years ago

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

unnijoy's avatar
unnijoy
Post Prodigy
4 years ago

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.