Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm trying to create simple group by
Sum cash in = GROUPBY(Table3,Table3[Industry],Table3[Month],"net revenue" ,SUMX(CURRENTGROUP(),[Net Revenue Vat included]))
but it gives me an error: The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.
Solved! Go to Solution.
https://msdn.microsoft.com/en-us/library/mt163693.aspx
"Return Value: A table with the selected columns for the groupBy_columnName arguments and the grouped by columns designated by the name arguments."
Group by returns a table, not a scalar value. This is exactly what this error message is saying.
https://msdn.microsoft.com/en-us/library/mt163693.aspx
"Return Value: A table with the selected columns for the groupBy_columnName arguments and the grouped by columns designated by the name arguments."
Group by returns a table, not a scalar value. This is exactly what this error message is saying.
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |