Beginning DAX with Power BI: The SQL Pro’s Guide to Better Business Intelligence

© Philip Seamark 2018

Philip SeamarkBeginning DAX with Power BIhttps://doi.org/10.1007/978-1-4842-3477-8_8

8. Debugging and Optimizing

Philip Seamark¹ 

(1)

UPPER HUTT, New Zealand

 

Debugging in DAX

A good question in any language is, “How can I debug the code?” Some languages have sophisticated tools that provide the programmer with the ability to walk step by step through execution of the code as the application runs. These debug tools often allow you to pause at various points to inspect all nature of useful properties and values so you get a clearer idea on the actual flow of logic as it pans out. This is not always the path the you expect, but at least being able to debug can help you identify sections of code you need to improve.

Unfortunately, ...