Forum Discussion

DHB's avatar
DHB
Icon for Helper V rankHelper V
9 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
    9 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
9 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"
)))))))

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

That's awesome.  It works perfectly, thank you Eno1978.