Uses for DAX as a Query Language-This is the final article in my series about DAX as a Query Language. In my first article I introduced DAX as a Query Language and then in my second article I went in deeper to the specifics on how to use some of the more useful DAX query functions. In this final article today […]Read More
DAX as a Query Language Part 2-In my last article I introduced DAX as a Query Language and explained why learning to query your data model can be useful. I covered the basics about using a tool like DAX Studio to query a database and return a table of data as a result. In this article I am going to go […]Read More
An Introduction to DAX as a Query Language-Level: Intermediate I have written quite a few articles that contain embedded references to DAX Queries and DAX Table functions in the past. Today I am writing an article that introduces the DAX query language from the beginning so you can learn how to use it and how it will help you to become a […]Read More
Extract Tabular Data From Power BI Service to Excel-Someone asked me a question yesterday about exporting data from the Power BI Service into Excel. There are a few options to do this however they all have their problems (these problems are not covered in great detail in this post). Power BI has an inbuilt export data feature (there is an export limit of […]Read More
Quadruple Nested SUMX or CROSSJOIN-Level: Intermediate I had an interesting problem with a client last week where I built a data model to calculate rebates payable to customers based on their sales turnover. There were a few challenges that I am going to cover below, including: There needs to be a user friendly way to capture the rebate data, […]Read More
Getting Started with DAX Studio-Level: Beginners DAX Studio is a fabulous free tool that allows you to directly query your Power Pivot/Power BI data models. It is not immediately obvious (particularly to beginners) exactly how using DAX Studio can add value. I often refer people on various forums to use DAX Studio but then lack a suitable reference to […]Read More
DAX Query Tables in Excel 2010-I was helping a participant at http://powerpivotforum.com.au with a problem. Long story short, she needed to return a table to Excel from a data model – not a Pivot Table. This concept can be a bit strange at first – let me explain. Tables – Not Pivot Tables A Pivot Table is a tool that […]Read More
Bring your data to life - Let's discuss how Matt can help!