Forum Discussion
Using calculated columns in sharepoint list in BI
Hi All, I have a list on sharepoint where i have a start date and an end date, i am using a calculated column to work out how many working days are between the two dates. I then have a hidden col...
Lalit Mohan I am afraid neither of these approaches worked.
When setting up a new view in Sharepoint there was no option to sum the values when grouped and when importing the data into power BI there was still no option to sum the Amount Due data.
I just get the option to count it.
Make sure you set any number columns to number type in the query editor - it may be defaulting to text type. Anything it doesn't recognize as a number it will try to count instead of sum.
- I can't get the Total Calculation to work either. In the example above, the "Days * 30" column is still calculated. I can go to Group By settings to group by it (or anything else) but I still need to go to Totals settings to select the Sum option. All the columns that contain text only have the option to Count. The number fields have Count, Average, Max, Sum, etc, but the required column name is not listed at all (I assume, because it's a calculated column).
Can you please provide more detailed explanation of where I find the Group by settings that allow me to sum the required column.
