LASTDATE column with identical values

[Mer333]

Hello again!

I came across an error about LASTDATE formula which isn't work for column with identical values (I have a column with a few repeating dates).

Any ideas how to fix it?

 

[Tianbas]

LASTDATE also works with identical values in the same column (at least it does in my files). Can you describe what is not working (wrong date or error message?) and/or share the workbook

 

[Mer333]

Here is an example:

https://www.sendspace.com/file/cx53el

I have really no idea why it happens (error I mean, when you will try to add measure LASTDATE to the table), because you are right - if I just create new table with 2 identical values - it works.

 

[scottsen]

Might be an easy solution here to just use MAX()?

LASTDATE and MAX are slightly different, with MAX only returning a scalar, and LASTDATE returning a table (of 1 value that can be converted into a scalar)... but most people wouldn't care

 

[Mer333]

Yeah, MAX() functions works here avoiding this error. It makes me stunned. =) Thank you! =)