Forum Discussion

rayinOz's avatar
rayinOz
Icon for Helper III rankHelper III
9 years ago
Solved

Finding Percent Complete by course by division

Hello All!   I  need help creating a chart that shows completion rate for course enrolments. This is the percentage of course status marked "complete" by course and by division. The previous employ...
Need Help
rayinOz's avatar
rayinOz
Icon for Helper III rankHelper III
9 years ago

I came up with the following but for some reason, it returns an error..

 

CourseStatusNew = IF(SEARCH('UoM-report'[Course Status],"Completed"),"Completed","Incomplete")

 

Basically what I want it to do is search the Course Status column and if it has a status of Completed, then the result is Completed, if it is anything other than complete (such as in progress or not yet started or extempted, etc) to set it as Incomplete.

 

Thoughts?

parry2k's avatar
parry2k
Icon for Super User rankSuper User
9 years ago

Here is what I think you need

CourseStatusNew = IF(SEARCH("Completed", 'UoM-report'[Course Status]),"Completed","Incomplete")
  • rayinOz's avatar
    rayinOz
    Icon for Helper III rankHelper III
    9 years ago

    Hmm... still the same error.. i've attached a screenshot... The column i want to search is Course Status... the column next to it is a manual one that was done in Excel and that i want to do away with once i get the function to work correctly in Power Bi.

     

     

     

     

     

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      9 years ago

      You are in edit query, not writing DAX formula.

       

      As mentioned previously, go to add column tab, click conditional column and it will stratight forward from there. Try it and let me know.

      • parry2k's avatar
        parry2k
        Icon for Super User rankSuper User
        9 years ago

         

        Hope this will be helpful :)