Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
steen_p
Helper II
Helper II

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
Anonymous
Not applicable

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
Anonymous
Not applicable

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

 

Hi @Anonymous ,

 

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

v-diye-msft
Community Support
Community Support

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.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors