cancel
Showing results for
Did you mean:
Frequent Visitor

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

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 "

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

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

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

For learning resources/Release notes, please visit: | |
3 REPLIES 3
Senior Member

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

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

Frequent Visitor

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

@NickNg278

but i want do DAX calculation On Existed Table..

Community Support Team

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

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

For learning resources/Release notes, please visit: | |