A table of multiple values was supplied where a single value was expected

[sreenu]

Dear Team,

I have created a table like order .By using dax function I created a date column like date= CALENDAR(DATE(1990,01,01),DATE(1998,12,31)).I am trying to crating another column same like this but it is shown as "A table of multiple values was supplied where a single value was expected".How I can resolve this issue.

Thanks.

[v-yulgu-msft · Accepted solution]

Hi @sreenu,

Were you trying to add a calculated column with this DAX?

date= CALENDAR(DATE(1990,01,01),DATE(1998,12,31))

This is not supported. As CALENDAR function returns a Table rather than a column. You can use this function to generate a calculated table.

Best regards,

Yuliana Gu