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

[SrinuReddy]

when Im Created dax new Column Like

Date= calendar(date(2013,1,1),date(2016,12,31)

im getting error like

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

[Anonymous]

@SrinuReddy,

CALENDAR returns a table so you have to use New Table instead of New Column

[SrinuReddy]

@Anonymous

but i want do DAX calculation On Existed Table..

[v-shex-msft · Accepted solution]

HI @SrinuReddy,

Calendar function can't direct use in calculate column, you need to do some summary for result table to summary result.

Sample:

Date =
COUNTROWS ( CALENDAR ( DATE ( 2013, 1, 1 ), DATE ( 2016, 12, 31 ) ) )

Date = MAX ( CALENDAR ( DATE ( 2013, 1, 1 ), DATE ( 2016, 12, 31 ) ) )

Date = MIN ( CALENDAR ( DATE ( 2013, 1, 1 ), DATE ( 2016, 12, 31 ) ) )

Can you share some sample data with expected result to help us clear your requirement?

Regards,

Xiaoxin Sheng