Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Good afternoon, I am using the formula below to obtain an average of multiple columns; however, when I add the measure to the matrix I get the message "cannot load the data because the function AVERAGE cannot work with values of type String". How can I solve this? Any suggestions?
(AVERAGE(Table2[SAP SRM Functionality])+average(Table2[SAP SRM Productivity])+average(Table2[SAP SRM Quality])+average(Table2[SAP SRM Support]))/4?
Solved! Go to Solution.
you need to change the data type of columns to a summable column, ie decimal or whole number, as its currently a string.
Proud to be a Super User!
you need to change the data type of columns to a summable column, ie decimal or whole number, as its currently a string.
Proud to be a Super User!
Thank you!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
60 |
User | Count |
---|---|
197 | |
118 | |
108 | |
78 | |
69 |