Difference between Dax codein Power BI and Dax in Dax studio

Power Query
1

Hi all trust this meets you well.

Please I would like to ask difference between writing dax code on PBI and writing dax code in Dax studio?

2

@Dave_Adejumo,

DAX Studio has a much better interface, with features like search and replace, built-in DAX formatter, etc. The downside is that while developing measures in DAX Studio is a much better user experience IMO, in order to test/run your measures you need to copy them back into Power BI.

Thus, for me the best solution has been to continue to work in the subpar DAX editor within Power BI, but to learn the keyboard shortcuts that dramatically improve the functionality of the built-in DAX editor (I actually printed them out on a mousepad to have them always available). If you go this route, check out this thread, where a number of us on the forum compiled a list of our favorite keyboard shortcuts, and posted the printable mousepad file:

Hope this is helpful.

  • Brian
3

Thanks boss… I really appreciate

4

@Dave_Adejumo,

:+1: - glad to help.

Even if you don’t use it for code editing, DAX Studio is an amazingly powerful and useful tool. Unfortunately, there aren’t a lot of good videos available on how to use it, but in the thread below @Paul provides a couple of good links that are definitely worth checking out.

  • Brian
5

Hi @Dave_Adejumo, please don’t forget if your question has been answered within the forum it is important to mark your thread as ‘solved’. Thanks!