Simple variable check

[Anonymous]

I am trying to check a variable in DAX Studio with the following syntax:

var YM = MAX('Calendar'[Date])
RETURN YM

Can't figure out why I get syntax error message.
Thank you!

[ValtteriN · Accepted solution]

Hi,

Try this kind of DAX: 
EVALUATE 

{MAX(latest[Date])}

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[Anonymous]

@AlexisOlson Thank you! 

[ValtteriN · Accepted solution]

Hi,

Try this kind of DAX: 
EVALUATE 

{MAX(latest[Date])}

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[AlexisOlson · Accepted solution]

@Anonymous The reason for this is that DAX Studio expects to be evaluation queries that return tables rather than single values. So you need to use the EVALUATE syntax and wrap a single value in braces { } since that denotes a list (a table with a single column).