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!
I tried disabling the auto date/time in settings with no luck. I'ts weird because i've used this dax formula in all my pbix files in the past with no issue.
johnt75Super User
can 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.