Forum Discussion
The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.
I figured it out...
It looks like Iwas trying to save a table expression as a measure. A measure requires a scalar output, but if the measure expression results in a columnar or table-like output, you will usually get this type of error. I had to try the expression in the new table dialog, instead of a new measure dialog. Thanks for your help!
Super UserThe only thing I can think to try is to go into DAX Query View and run
EVALUATE
ROW (
"@min", MINX ( 'PST', 'PST'[Date Worked] ),
"@max", MAXX ( 'PST', 'PST'[Date Worked] )
)
See what result that gives
I figured it out...
It looks like Iwas trying to save a table expression as a measure. A measure requires a scalar output, but if the measure expression results in a columnar or table-like output, you will usually get this type of error. I had to try the expression in the new table dialog, instead of a new measure dialog. Thanks for your help!