I've created below 'attempt' to create a new table. From what I've been able to find, I can't see what's incorrect about either the syntax or the content. any suggestions are appreciated.
Results in the following error message.
"The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."
Go to Solution.
Hi @RiceCake ,
Make sure you click the "New Table" button instead of "New Measure" to generate a calculated table. Also, the DAX formula could be simplified as:
SUM ( T_Historic_Monthly_Commercial_Forecast[Commercial Forecast] )
Thanks a lot @v-yulgu-msft
next question is then if I can include / add conditions to this sum. I tried adding a filter, but ended up with error message, probably related to syntax.
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!