Crossjoin Returns Error

[UncleLewis]

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.

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

[UncleLewis]

Thanks gents!

-w

[Fowmy · Accepted solution]

@UncleLewis 

Under the modeling tab, click on New Table and enter your code:

[amitchandak]

@UncleLewis , This returns a table. Seem like you are trying to create a measure.

Create a new table using this