Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Improve Existing Dax via Calculated Column

Hi All,   I have a dataset similar to the below.   UP Activity/Skill Type Calculated Column _ Day Work _ Day Work Unit Rate Unit Rate Non Billable Unit Rate Non-Billable Ze...
Need Help
Show and Tell
Tips and Tricks
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi Anonymous ,

     

    Try this:-

    Column = SWITCH(TRUE(),
CONTAINSSTRING('Table (2)'[UP Activity/Skill Type],"_"),"Day Work",
CONTAINSSTRING('Table (2)'[UP Activity/Skill Type],"Unit Rate"),"Unit Rate",
"Non Billable")

     

    Output:-

     

    Thanks,

    Samarth

     

     

Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Anonymous ,

 

Try this:-

Column = SWITCH(TRUE(),
CONTAINSSTRING('Table (2)'[UP Activity/Skill Type],"_"),"Day Work",
CONTAINSSTRING('Table (2)'[UP Activity/Skill Type],"Unit Rate"),"Unit Rate",
"Non Billable")

 

Output:-

 

Thanks,

Samarth