Tag: Power BI Tips

Creating Multi Threaded Dynamic Visuals – Advanced Power BI Technique

Creating Multi Threaded Dynamic Visuals - Advanced Power BI Technique

In this post, I want to show you what is without a doubt one of the most compelling visualisation techniques in Power BI. Never feel you are confined to use just the general visualisation options inside of Power BI (or custom visuals for that matter). You have a significant opportunity to make your visuals even

Continue reading

Discover The INTERSECT Function In DAX And How To Utilize It – Power BI Tutorial

Discover The INTERSECT Function In DAX And How To Utilize It - Power BI Tutorial

The INTERSECT function in Power BI is an advanced table function and to understand how it works, you will want to get much better at understanding virtual tables. Virtual tables are a key concept when utilizing DAX measures within Power BI. What the INTERSECT function does specifically is that it allows you to – within a

Continue reading

Discover What Was The Initial Product A Customer Purchased Using DAX

Discover What Was The Initial Product A Customer Purchased Using DAX

I have another really unique insight to showcase to you in Power BI today. This is unique not only in the actual insight but in terms of how we can return a text value inside a Power BI table. The function that enables us to do this is SelectedValue. This particular function is really powerful

Continue reading

Calculate Consecutive Weekday & Weekend Days In Power BI Using DAX

Calculate Consecutive Weekday & Weekend Days In Power BI Using DAX

We’re going to work through something really unique around Time Intelligence inside of Power BI. This scenario was brought up on the Enterprise DNA Support Forum, where there was a need to compare “like-for-like” within months. In other words, they wanted to compare the first working day in a particular month to the first working

Continue reading

Discover The Amount Of Customers Who Purchase Multiple Products w/Power BI

Discover The Amount Of Customers Who Purchase Multiple Products w/Power BI

We’re going to review a unique customer insight in this example. Specifically, we’re going to understand how to work out the number of customers who have purchased more than one product. While this might seem like a relatively logical calculation, there’s actually more to it when using DAX. This is a perfect example of how

Continue reading