Advanced - Excelerator BI

Advanced

Affordable Power BI Premium for Small Business (Part 2)

Level: Advanced This is the second in my series of articles explaining how to use Microsoft Flow, the Azure APIs, the Power BI APIs and SharePoint Online to help make Power BI Premium more affordable …

Affordable Power BI Premium for Small Business (Part 2) Read More

Affordable Power BI Premium for Small Business (Part 1)

Level: Advanced This is another one of those articles that has been swirling in my head for a very long time, about 2 years actually.  I have long been frustrated by the lack of a …

Affordable Power BI Premium for Small Business (Part 1) Read More

Introduction to DirectQuery

Level: Intermediate to Advanced Matt here.  I recently met Parker Stevens online through LinkedIn – he too is a Power BI fan, just like me.  Parker has shared a few techniques with me that I …

Introduction to DirectQuery Read More

Show Me All Invoices Containing this Product

Level: Advanced I was answering an interesting forum question last week, and as is often the case I thought it would make an interesting article to share with you all here.  I have modified the …

Show Me All Invoices Containing this Product Read More

EARLIER vs EARLIEST in DAX

Level: Advanced The EARLIER() and EARLIEST() functions are 2 of the harder functions in DAX to get your head around. If you come from a programming background it will probably be easy for you.  However …

EARLIER vs EARLIEST in DAX Read More

Lineage in DAX

Level: Intermediate–Advanced I have covered the topic of Lineage in DAX a few times in the past (within other articles).  Today I thought I would write a single post dedicated to lineage. As you may …

Lineage in DAX Read More

How To Solve a Complex DAX Problem

Level: Advanced I was helping someone on Power Pivot Forum last week with a tricky calculated column question.  As an aside, you may know that I always advise beginners to keep away from calculated columns. …

How To Solve a Complex DAX Problem Read More

Cumulative Running Total Based on Highest Value

Level: Advanced I’ve helped a couple of people out on various forums on this topic over the last week, and that is normally a good sign that I need a blog post on the topic. …

Cumulative Running Total Based on Highest Value Read More

Many to Many Relationships in DAX Explained

Level: Advanced (Level: Advanced, but explained in detail so everyone can understand) There is a lot to learn in DAX if you want to be a ninja.  A couple of the more complex and important things …

Many to Many Relationships in DAX Explained Read More

Scroll to Top