Forum Discussion

DHB's avatar
DHB
Icon for Helper V rankHelper V
10 years ago
Solved

DAX IF formula

  Hi all,   I’m trying to write a DAX formula to give me a new column with one of the following values based on the submission type; submission_types NEW COLUMN Discussion topic Di...
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    DHB I'm not aware of how to get around the first requirement, I'd just add the additional "IF". the second one searching for "media" in the value should be resolved using the added syntax I have below:

    Column =
    IF('assignment_dim'[submission_types] = "discussion_topic","Discussion",
    IF(assignment_dim[submission_types]= "online_upload", "Plain Assignment",
    IF(assignment_dim[submission_types]= "external_tool", "External Tool",
    IF(assignment_dim[submission_types]= "not_graded", "Ungraded",
    IF(assignment_dim[submission_types]= "online_quiz", "Quiz",
    IF(assignment_dim[submission_types]= "none", "Plain Assignment",
    IF((SEARCH("*media*", assignment_dim[submission_types],1,0)>0)= TRUE, "Media Content","Other"
    )))))))

Anonymous's avatar
Anonymous
Not applicable
10 years ago

DHB You need to create a calculated column, it would appear you are trying to create a measure.

DHB's avatar
DHB
Icon for Helper V rankHelper V
10 years ago

You're right.  It's all working pefectly now.  I've just got to build it up to cover some other submission types.

 

thanks so much for your help.

 

DHB