Tag: CALCULATE

Analyze Who Your Lost Customers Are Using Power BI & DAX

Use CALCULATE table function to determine the lost customers

In this example we’re going to dive into some customer churn analysis in Power BI. Power BI is an amazing tool for high-quality analytics. It does not have a close competitor at this point in time in my view. In this particular example, I’m going to show you how we can not only work out

Continue reading

Calculate A Reverse Cumulative Total In Power BI Using DAX

In this example, I will show you how you can create a reverse cumulative total inside of Power BI using DAX. This question came up recently on the Enterprise DNA Support Forum. You can view this forum post here – Reverse Cumulative Sum A member had a unique requirement where they needed a cumulative total from

Continue reading

Using Dynamic Visuals On Ranking Based Parameters In Power BI

Using Dynamic Visuals On Ranking Based Parameters In Power BI

Through this example I’m going to show you how you can dynamically adjust the size of your visual. And in this case, we’re going to do it via the result ranking. This is a really powerful technique that you can utilize in Power BI. Never think you are limited to the standard ‘out of the

Continue reading

How To Work With Multiple Dates In Power BI

How To Work With Multiple Dates In Power BI

As soon as you start developing a few Power BI models, you’ll very likely run into this problem … You have two dates in your fact table (your transaction table) and you can’t place two relationships between your date table and the other table. You might even have multiple dates, like entered date, ordered date,

Continue reading

Calculate Financial Year To Date (FYTD) Sales In Power BI using DAX

Calculate Financial Year To Date (FYTD) Sales In Power BI using DAX

One thing that can seem like a limitation of Power BI is its calendar date table. Often, you’ll need to calculate results across a custom financial year, but only the standard date table is available. You may initially think that you need a new date table, but you don’t. You can use DAX in either

Continue reading