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 UserHave you disabled Auto Date/Time in settings ? If not, Power BI will have automatically created a date table which is referenced by PST[Date Worked]. Either disable auto date/time ( preferably ), or else you can replace the PST[Date Worked] with PST[Date Worked].Date.