Tag: Advanced Analytics Power BI

Power BI Financial Year To Date Calculations

Power BI Financial Year To Date Calculations

In this tutorial, I’m going to talk about Power BI financial year to date calculations. Achieving a year to date analysis of a selected period is quite complex, but I’ll demonstrate to you a formula technique that enables you to quickly create a cumulative total over your specific financial year. You can watch the full

Continue reading

Power BI Banding & Segmenting Example Using DAX

In this tutorial, I go over a Power BI banding and grouping example using the DAX formula. This is quite an advanced example, but it does show an awesome way that you can visualize your reports. You may watch the full video of this tutorial at the bottom of this blog. Sometimes, you might want

Continue reading

Cross Selling Matrix In Power BI Using DAX

Cross Selling Matrix Deep Dive - Power BI & DAX Tutorial

In this tutorial, I show you how to create a cross selling matrix in Power BI. This is just a preview of a session that I conducted in an Enterprise DNA Learning Summit. You may watch the full video of this tutorial at the bottom of this blog. This technique that I’ll demonstrate can add a

Continue reading

Power BI Data Model For Advanced Scenario Analysis Using DAX

I want to show here how incredible Power BI is as an analytical tool. I’ll teach you how to develop a Power BI data model for an advanced scenario analysis. You may watch the full video of this tutorial at the bottom of this blog. With Power BI, we can achieve so much that we

Continue reading

How To Implement Cohort Analysis In Power BI – Advanced DAX Concepts

In this blog, I am introducing Power BI cohort analysis. This was one of the topics that I went through in detail in a Learning Summit, where I demonstrated what cohort analysis is and how you can do it in Power BI. In this tutorial, you will learn how to set it up inside your

Continue reading