Forum Discussion
Solved
Crossjoin Returns Error
Hi,
Using PBI Desktop 2.97 (September, 2021)
I have 2 table in the Data Model : Date, Profit Center
I tried using these in a CROSSJOIN:
Test = CROSSJOIN('Date','Profit Center')
But it returns an error: The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.
But it returns an error: The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.
However, the formula seems correct based on this article:
https://docs.microsoft.com/en-us/dax/crossjoin-function-dax
What am I doing wrong?
Thanks,
-w
https://docs.microsoft.com/en-us/dax/crossjoin-function-dax
What am I doing wrong?
Thanks,
-w
3 Replies
UncleLewis , This returns a table. Seem like you are trying to create a measure.
Create a new table using this
Thanks gents!
-w
