Forum Discussion

andronachealin's avatar
andronachealin
Frequent Visitor
5 years ago
Solved

Calculated DAX column with multiple If statements

Hi all,   I would like to create a calculated column using DAX, titled Curriculum Status, that will apply the following logic: For each User ID (column C), if all course IDs in column B are mappe...
  • lbendlin's avatar
    lbendlin
    5 years ago

    I didn't understand this part " if all course IDs in column B are mapped to the curriculum in column A "  and it doesn't seem to matter for your desired result.

     

     

    Curriculum Status = 
var s = CALCULATETable(values('Table'[Course Status]),ALLEXCEPT('Table','Table'[User ID]))
return if(concatenatex(s,'Table'[Course Status],",")="Completed",s,"Incomplete")

     

lbendlin's avatar
lbendlin
Super User
5 years ago

I didn't understand this part " if all course IDs in column B are mapped to the curriculum in column A "  and it doesn't seem to matter for your desired result.

 

 

Curriculum Status = 
var s = CALCULATETable(values('Table'[Course Status]),ALLEXCEPT('Table','Table'[User ID]))
return if(concatenatex(s,'Table'[Course Status],",")="Completed",s,"Incomplete")

 

andronachealin's avatar
andronachealin
Frequent Visitor
5 years ago

lbendlin True. I did not really need that condition.
Thanks for the solution. Works like a charm. Much appreciated.