Creation of a Data Table and getting an error.

[kamini]

Hi,😀

I'm trying to create a data table and getting the following error,

DateTable = 
ADDCOLUMNS (
    CALENDAR (MIN('ITD Projects'[Created date]), MAX('ITD Projects'[Finish date])),
    "Year", YEAR([Date]),
    "Quarter", "Q" & FORMAT(QUARTER([Date]), "0")
)

The expression refers to multiple columns. Multiple Coumns cannot be converted to a scalar value. 

I have changed both Created date and Finish date to date types. 

Please help.

Thanks,

[OwenAuger · Accepted solution]

Hi @kamini

Based on the error message, are you possibly trying to create a measure rather than a table?

The DAX expression itself looks fine for a calculated table.

Try selecting Modeling > New table and entering the expression. Does that work?