Forum Discussion
Data to sum not recognized
Hi StefanoS,
Please share your pbix file if possible. At least a sample and some snapshots.
Best Regards!
Dale
Hi Dale v-jiascu-msft,
thanks for your reply and apologize for my answer's delay.
referring to my previous message Column "A" is the column AQ in the first picture below (PowerBi source file), Column "B" is column AG.
Column AG is part of original file, column AQ is created with a formula linked to AG (a simple percentage), I tried either to keep AQ as formula and to copy and paste it as value, but no results.
Basically I want PowerBi treats AQ as AG. As you can see from the pictures 2 and 3 below PowerBi sums column AG (picture 2) but it doesn't do the same with column AQ (picture 3), it shows only "First", "Last", "Count" and "Count Distinct" as options.
Even the column AC in source file (quantity), which is not formatted as accounting, is summarized in PowerBi with the same visualization (Card) and it's the card showing "30K".
All the 3 columns in source file (AC, AG and AQ) have some "blanks" or zero value for some rows.
How is it possible I cannot sum the column AQ in Power Bi?
thank you in advance.
123
Again, these are the options you get for columns that are recognized as text. There is probably one row in AG that has non-numeric data in it, so when you load it into Power BI the entire column gets treated as text. It's all or nothing. If even a single row cannot be recognized as a numeric value or null, Power BI cannot treat that column as a number. Screenshots are of little use here if you can't find the problem on your own. We would need to see the source excel file at least, preferably also the pbix file as well.