Tag: Advanced DAX Combination

Power BI CALCULATE: Key To Advanced DAX Formulas

Now we are going to dive into the CALCULATE function in Power BI. We have already used the function many times but this is where I want to discuss it in detail. Getting The Sales Last Year With CALCULATE The CALCULATE function allows you to change the context of a calculation within a measure wherein

Continue reading

How To Calculate Difference In Days Between Purchases Using DAX In Power BI

You’ll learn in this tutorial how to calculate difference in days between purchases using DAX in Power BI. This topic came from the Enterprise DNA support forum and I’ll show you how I solved it. This is an interesting scenario and quite common in the business world. In this example, we’re looking at a customer

Continue reading

Measure Branching: Power BI Development Strategy

I’d like to share with you a development strategy or concept in Power BI called measure branching. This is one of my favorite topics in Power BI especially around DAX formula. I personally use this technique and you’ll see me apply it often in many of my tutorials. It’s how I build high quality and intuitive

Continue reading