Rating calculation.xlsx (12.7 KB)
I need help with the DAX formula for the attached excel sheet.
I have survey results with ratings of Very Dissatisfied, Dissatisfied, Neutral, Satisfied, and Very Satisfied. I want to be able to show an overall/final rating (3.72 in yellow highlight). Can you please help/guide me on how to write the dax formula?