Forum Discussion

fergmn's avatar
fergmn
Frequent Visitor
3 years ago
Solved

SUM/Count in Power Bi

Hi, I was wondering if there is a way to sum my sales data instead of it showing the count in PowerBi. I want to look at the sum of sales instead of the count in some of my charts. 
Need Help
Tutorial Requests
  • JirkaZ's avatar
    JirkaZ
    3 years ago

    Well I believe the error message says it all. The HMO[Sales] field is a text field - not a numerical field. You have change the type of the field first.

JirkaZ's avatar
JirkaZ
Solution Specialist
3 years ago

Well I believe the error message says it all. The HMO[Sales] field is a text field - not a numerical field. You have change the type of the field first.

fergmn's avatar
fergmn
Frequent Visitor
3 years ago

This definately solved my issue. Thank you so much.