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

[rkumar]

Hi All,

I am getting the mentioned error while working with date columns . 
To find latest updated date depending on different departments. 
Tried using lastdate for find the same bit it gives the same error. is there any way or workaround to fix this.

Thank you 

[v-yuezhe-msft · Accepted solution]

@rkumar,

A simple example for your reference. Right click your table, select "New Measure", then apply the following DAX.

Latest date=LASTDATE(Table[Date])


Regards,
Lydia

[rkumar · Accepted solution]

LASTDATE formulae is working fine when tested with some dummy data . It seems there is some other issue that we need to find in the data.

[v-yuezhe-msft · Accepted solution]

@rkumar,

A simple example for your reference. Right click your table, select "New Measure", then apply the following DAX.

Latest date=LASTDATE(Table[Date])


Regards,
Lydia

[rkumar · Accepted solution]

LASTDATE formulae is working fine when tested with some dummy data . It seems there is some other issue that we need to find in the data.

[v-yuezhe-msft · Accepted solution]

@rkumar,

How is the issue going? If you have solved the issue, please accept appropriate reply as answer to close this thread.

Regards,
Lydia

[Greg_Deckler]

Can you post your formula and maybe some sample/fake data?

[rkumar]

Hi Smoupre,
Thanks for the reply . LASTDATE formulae is working fine when tested with some dummy data . It seems there is some other issue that we need to find in the data. will work on same and if there are any further queries ,will revert you on the same .

Thankyou