cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Showing the value of a variable in DAXStudio

Hi,

 

This might be a little bit off-topic, but I hope someone can help anyway.

 

I'm using DAXStudio to write some DAX queries and I'd like to be able to show the value of a scalar variable for debugging purposes, but I simply can't figure out how to do it. I can show the content of a table variable, so how do I do it with a scalar variable.

I e.g. have a Month-Year variable where I'd like to verify that it contains the right value, so does anyone know how I can show that in DAXStudio?

 

Regards

Steen

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver I
Resolver I

Re: Showing the value of a variable in DAXStudio

Hi @steen_p ,

 

As we know, dax studio can only get the row of a table. So we cannot get the Aggregated value directly. We can use ROW to work around like that.

EVALUATE
row ("a",today())

3.PNG

 

View solution in original post

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: Showing the value of a variable in DAXStudio

Hi @steen_p 

 

You might refer to this document:

https://exceleratorbi.com.au/getting-started-dax-studio/ 

 

If you'd like to write some DAX formulas, kindly provide the data with desirables, we'd like to draw it up for you.

 

 

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
Highlighted
Resolver I
Resolver I

Re: Showing the value of a variable in DAXStudio

Hi @steen_p ,

 

As we know, dax studio can only get the row of a table. So we cannot get the Aggregated value directly. We can use ROW to work around like that.

EVALUATE
row ("a",today())

3.PNG

 

View solution in original post

Highlighted
Frequent Visitor

Re: Showing the value of a variable in DAXStudio

Hi @Frank_Fei ,

 

Thanks for your input.

I actually ended up doing something similar - I just used SUMMARIZECOLUMNS , but it's a little bit easier to use ROW.

 

Thanks

Steen

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors