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

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