Category: DAX

Customer Segmentation Techniques Using The Data Model – Power BI & DAX

In this video tutorial I’m going to show you how you can segment your customers in an efficient way via the data model in Power BI. Sometimes your raw data will not have all the information you require to showcase something in Power BI. But don’t let this stop you. All you require is an

Continue reading

How To Use The CROSSJOIN Function – Power BI & DAX Tutorial

CROSSJOIN is a really effective function that you can utilize inside of Power BI to essentially bind two tables of data together. It’s not just about selecting any two tables from your data sets. What you can do is actually also manipulate tables inside of the CROSSJOIN function so they can be joined in a

Continue reading

Deep Dive Into ALLSELECTED – DAX Function In Power BI

The ALLSELECTED function inside of Power BI is a complex DAX function. It is one of the more advanced functions that you can utilize within your reports and dashboards. In my view, it is one that you have to learn well. You can’t just forget about it and not focus on ways you can utilize

Continue reading

How To Calculate Actual Results To Budgets Per Product – Power BI & DAX

In this advanced video tutorial which is a breakout of a budgeting workshop that was part of the Enterprise DNA webinar series, I am going to run through how you can utilize some advanced functions inside of Power BI like CALCULATE, ALLSELECTED and SUMMARIZE. By using all the functions in combination we are able to

Continue reading

Enterprise DNA Learning Summit – August 2018 [Event Announcement]

The next Enterprise DNA Learning Summit is just around the corner. We’re taking the content up another level for this one. There will be a significant amount of content covered during these advanced Power BI development sessions planned for this event – 6 free live workshops in total. Yes, this is a completely free training

Continue reading