Forum Discussion
The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.
Hello, I am trying to create a date table and I am receiving the following error: "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value." Below is...
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!
johnt75
Super User
Super Usercan you post a screenshot showing the date worked column in the PST table ? It doesn't look like there's anything wrong with the DAX.
- johnt75
Thanks. That's the Power Query view, can you show it in the desktop view, ideally the view in the data pane rather than the underlying data.
Like this?
- johnt75
The 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