Forum Discussion
Problem with ECTS Calculation in Power BI
Good Day everyone.
I have a deadline to deliver some calculations. Iam in the education field and i need to calculated ECTS of students.
Context: I am working on a project to analyze the credit allocation for a university's degree programs using the ECTS system.
Objective: My goal is to calculate the total ECTS credits for each program based on the course credits and their respective weightings.
Data: I have a dataset containing information about each course, including credit hours, ECTS coefficients, and the program it belongs to. A piece of the data is in an Excel file.
Calculation method: I am using the following formula to calculate ECTS credits:
- If the score is less than or equal to 4, we do not multiply it by its corresponding weight, because the student cannot receive ECTS for that subqualification as a whole. It doesn't qualify.
- If the score is greater than 4, we multiply the numerical score by its corresponding weight.
- Then we add up all the products from the partial exams, and if the sum is greater than or equal to 5.5, the student receives ECTS points for that subqualification.
Problem description: I am having trouble implementing this formula in Power BI and getting accurate ECTS credit calculations for each program.
Steps taken: I have tried using a calculated column in Power BI with a DAX formula, but the results seem incorrect. I have also attempted to calculate ECTS credits in Power Query, but I am not sure if this is the best approach.
2 Replies
Hello v-zhangti,
I appreciate your prompt assistance and willingness to help. I apologize for the delay in my response, I was unable to reply promptly due to urgent matters.
In the meantime, I was able to find a solution to the problem I was facing. The issue has now been resolved and I'm moving forward with my project. While I won't be requiring sample data or assistance in formulating expected results at this moment, I truly value your support and will not hesitate to reach out if I encounter further challenges.
Thank you once again for your understanding and for the helpful resources you provide in this community.
Hi, tobinho
Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures or Excel. I look forward to your response.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
