topic Re: Simple variable check in DAX Commands and Tips

Simple variable check

Anonymous — Mon, 31 Jan 2022 17:37:45 GMT

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!

Re: Simple variable check

ValtteriN — Mon, 31 Jan 2022 17:55:14 GMT

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/

Re: Simple variable check

AlexisOlson — Mon, 31 Jan 2022 18:08:54 GMT

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).

Re: Simple variable check

Anonymous — Mon, 31 Jan 2022 18:14:20 GMT

AlexisOlson Thank you!