Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Need help on DAX

Hi,I have data as below in the second picture. I need to create a calculated column based on the values of enter_by.1,enter_by.2 and so on. The data also has a region_id column. Have a mapping table ...
Need Help
parry2k's avatar
parry2k
Super User
7 years ago

Anonymous what you want to achieve the end result? Just calculated column? How you want to use it? THe formula you showed what is the problem wiht that?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks for replying.

 

Can I achieve something like this using DAX?

 

I had written the formula in Power Query and was working there.

What about using nested ifelse in DAX for a calculated column?

WHat is the best practice?

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Anonymous yes you can surely achieve the same with DAX 

    My Column in Dax = 
if( Table[Column] = Value, <then condition>,
if( Table[Column] = Valie, <then condition>,
<else condition>
)
)