Tag: Power BI Techniques

Advanced Transformations in Power BI

Let me discuss some advanced transformations in Power BI through the query editor. Remember that you can combine different actions within the query editor to fully optimize your models. It’s just a matter of familiarizing yourself with the different transformations in Power BI and finding out what scenarios they’re useful for. Exploring The Different Transformations

Continue reading

Simple Power BI Transformations For More Optimized Data

I’m going to talk about simple Power BI transformations you can do around the query editor. The query editor allows you to clean up your data and transform it from its rawest form. Although it allows you to do some really advanced transformations, I want to focus on the simple ones you can do. Through

Continue reading

How To Use The COUNTROWS DAX Function In Virtual Tables

I want to dive deeply into how useful the COUNTROWS DAX function can be. You could be a newbie who hasn’t fully grasped how COUNTROWS works. You could also be a more experienced Power BI user but are unsure of how you can maximize the function. Through the examples I’ll be giving below, you’ll see

Continue reading

The Difference Between SUM vs SUMX In Power BI

SUM vs SUMX What's The Real Difference Between These DAX Measures

There is still a lot of confusion about the difference between SUM vs SUMX in Power BI. This is key knowledge that users have to master because both functions can be used across different scenarios, but there are cases where one is more efficient than the other. I’m going to focus on one example here

Continue reading

Calculating Dynamic Profit Margins – Easy Power BI Analysis With DAX

Calculating Dynamic Profit Margins - Easy Power BI Analysis With DAX

I want to go over how to calculate dynamic profit margins in Power BI. This is something I consider to be quite straightforward if you’ve been using Power BI for some time. But if you’re just starting out, this could be challenging to piece together. This kind of information is something that most organizations need.

Continue reading