Forum Discussion
The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.
Trying to Convert this SQL Code into DAx and it gives me "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value." SQl Code - SELECT s.Department,SUM(s.[He...
HI VinayMedishety,
What type of data source are you worked? If you are working with SQL , oracle data source, you can try to use these queries in data connector SQL statements. (you can find it in advanced option -> SQL statement)
BTW, these dax formula will return a table, you need use in calculated table expression instead of calculated column or measure.
Regards,
Xiaoxin Sheng