Tag: Variables

Why Using Power BI Variables Is A Better Way To Write DAX Measures

Why Using Variables Is A Better Way To Write DAX Measures - Power BI Admin Advice

Using variables is a great way to make sure that your results add up the way they should at the end of your measures. Variables are such a crucial part of writing and solving formulas inside Power BI and I’m going to show you why. Sample Data Visualized In Gantt Chart To showcase the importance

Continue reading

Master Virtual Tables in Power BI Using DAX

In this blog post, I’ll run through a truly powerful analytical technique which I’m confident will WOW anyone. Virtual tables are a unique analytical technique that you can use to visualize interesting insights inside Power BI. The example I’ll show is just one of the many techniques you can apply. I use the term “algorithms”

Continue reading

New vs Existing Customers – Advanced Analytics In Power BI

If you’re an online retailer or a high frequency sales operation, then understanding your customer base, like if they are new customers or existing customers, is a really high quality insight that you can achieve using advanced analytics in Power BI. You’ll want to dive into this type of analysis because you need to evaluate

Continue reading

How To Use The EARLIER Function In Power BI – A DAX Tutorial

Most DAX beginners and even intermediate users really struggle in understanding what the EARLIER function does. It also took me a long time to understand how, when and why you should use this function in Power BI. In this article, we are going to complete a deep dive into using the EARLIER function. I’ll show you

Continue reading

Using Variables In Power BI – A Detailed Example

How To Use Variables In DAX Power BI

In this post, I’ll show you how to use variables within your DAX formula in Power BI. Variables are a real game-changer for the formula bar in Power BI. Being able to break down your more complex formulas in steps makes setting them out much more intuitive. I keep thinking back to using VBA with

Continue reading