From complex business intelligence to data modelling and analytics scenarios, Data Analysis Expressions (DAX) can help you solve some curly problems with just a few clicks of a button in Power BI. Here at Sensei, we think being able to write DAX queries and achieve your desired output in a wide range of real-world scenarios is pretty invaluable. So, in this blog post we're going to show you our current favourite DAX tricks that we've used to solve business problems during Power BI implementations for our clients.

For the purpose of this blog post, we'll be assuming that you have used DAX before or know its application.