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

[waleed111]

when i make this formula :

Date = MAXX('List View',

CALENDAR(

MINX('List View','List View'[start date]), MAXX('List View','List View'[end date])

)

)

it gave me this error:

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

*Date: is a column.

what is the problem?

[v-xicai]

Hi  @waleed111  ,

Do the suggestions from engineers make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[waleed111]

my question is: why i cannot get column from this formula:

CALENDAR(

MINX('List View','List View'[start date]), MAXX('List View','List View'[end date])

)

it return table with single column just, then why it cannot used as a column.

[v-xicai]

Hi @waleed111 ,

You may create a calendar table like DAX below.

Calendar= CALENDAR(MIN( 'List View'[start date]), MAX('List View'[end date]) )

Or you would like to get the largest Date value of 'List View'[start date] and 'List View'[end date], the create measure like DAX below.

MaxDate= MAX(MAX('List View'[start date]), MAX('List View'[end date]))

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[waleed111]

i want to create a column using this formula:

date =

CALENDAR(

MINX('List View','List View'[start date]), MAXX('List View','List View'[end date])

)

but it show me this error:

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

[v-xicai]

Hi @waleed111 ,

From the article https://docs.microsoft.com/en-us/dax/calendar-function-dax, we know the CALENDAR function will returns a table with a single column named "Date" that contains a contiguous set of dates, and it should be used in a calculated table instead of calculated or measure, except used in variable.

The second argument of MAXX function should be a expression, while the CALENDAR() will return a table , which lets the error message appear.

So you may try to use the formulas which I have offered above to achieve your requirement.

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@waleed111 , if you want a date table

Date =
CALENDAR(
MINX('List View','List View'[start date]), MAXX('List View','List View'[end date])
)

a max date

Date = MAXX(
CALENDAR(
MINX('List View','List View'[start date]), MAXX('List View','List View'[end date])
),[Date]
)

it is as good as MAXX('List View','List View'[end date])