J on 12 Aug 2016 00:23:34
It's often hard to deal with the single formula bar in the data view or even the report view (when creating ad-hoc DAX measures/ calculated columns). It would be nice to have a new view designed to help debug DAX formulas similar in functionality to what has been done in daxstudio. I don't like having to use a separate application for debugging. https://daxstudio.codeplex.com/
- Comments (6)
RE: Dax Studio Capability
Right now, figuring out where the issues are in my DAX code is much more difficult than it should be. I would really like to be able to step through the process, so I can see where it's going sideways, like I can in Excel VB. Right now it's a lot of teasing apart and guesswork, which is so slow and annoying.
RE: Dax Studio Capability
I have not used DAX studio, but how about having the capabilities Similar to VisualStudio (VS)? Perhaps a cutdown version of VS could open up from a new button by the side of the formula bar.
RE: Dax Studio Capability
Agreed. There is way more real estate to write VB in Excel. DAX expression area should be similar size.
RE: Dax Studio Capability
This would be very helpful.
I tend to have to break the DAX expression up into separate parts when debugging, but that sometimes changes the context or creates an intermediate value that I can't directly see (ex tables).
It would be nice to be able to step through a DAX expression and see the results.
RE: Dax Studio Capability
In addition performance measurement of measures, would be awesome like DAX studio
RE: Dax Studio Capability
I agree. I haven't used DAXStudio, but does it display the value of variables (e.g. other measures) within your formula as you 'step' through (similar to VBA)?
If Power BI could do that, AND use the current context of filters (e.g. slicers selected, visuals/visual level filters selected), this would beat any external application.