Forum Discussion
Helper IIIFinding Percent Complete by course by division
No worries, I created a dummy data at my end, i can send you the file with formulas in it, basically in nutshell this is what I did:
created 3 measures to calculate
Total Completed
Total Completed = CALCULATE(COUNT(Student[Student]),FILTER(Student, Student[Course Status]="Complete"))
Total Courses
Total = CALCULATE(COUNT(Student[Student]))
% Completed
% Completed = [Total Completed] / [Total]
Added a column chart and added the value as below
and here is the output
You can change these formulas as per your data model and enhnace these as you feel like.
Cheers,
P
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.
Hope this will be helpful :)
Super UserHere is what I think you need
CourseStatusNew = IF(SEARCH("Completed", 'UoM-report'[Course Status]),"Completed","Incomplete")
Helper IIIHmm... 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.