Tag: Advanced DAX

Basket Analysis Introduction – Best Practice Tips For Power BI Using DAX

Basket Analysis For Power BI Using DAX

With Basket Analysis, what we’re trying to achieve is analyzing one grouping of products versus another grouping of products.  There’s plenty of application for this across Power BI. The theory we’re trying to work through with this type of analysis is if one grouping of products is bought with another grouping of products. By running

Continue reading

Layering Multiple Scenarios Analysis Using DAX in Power BI

Layering Multiple Scenarios Analysis Using DAX in Power BI

I’m huge on scenario analysis in Power BI. Being able to input variables inside your calculations that you can ‘shock’ to effectively predict outcomes is so powerful when trying to make decisions. In Power BI you can complete this really efficiently, and you can combine many of the formula techniques with your data models and

Continue reading

Explore Forecasting Logic In Your Power BI Models Using DAX

Explore Forecasting Logic In Your Power BI Models Using DAX

It doesn’t get more real world than the video below for an application of Power BI to provide great insight. In the example I run though here, I want to compare my actual results to my forecasted results. Not only that – I want to view these cumulatively. The cumulative totals give me a much

Continue reading

Discover How To Repeatedly Project A Current Trend Forward In Power BI

Discover How To Repeatedly Project A Current Trend Forward In Power BI

In this unique example, I want to show you how you can take a historical trend and repeatedly project it forward. This particular example came to me from a question in the Enterprise DNA support forum. An Enterprise DNA member needed to carry out this analysis in the real world. They had to take historical

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