cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SrinuReddy Frequent Visitor
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
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
NickNg278 Senior Member
Senior Member

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

@SrinuReddy,

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

SrinuReddy Frequent Visitor
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
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: | |