Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
Solved! Go to 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/
Proud to be a Super User!
@dandreev 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).
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/
Proud to be a Super User!
@dandreev 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).
User | Count |
---|---|
57 | |
48 | |
18 | |
16 | |
15 |
User | Count |
---|---|
116 | |
42 | |
41 | |
27 | |
21 |