Tag: power bi data transformation

Query Editor In Power BI | An Overview


In this tutorial, we’ll show a detailed example of why we always need to use the Query Editor in Power BI and what we can achieve when using it.  It’s deemed a best practice to always bring your data into the Query Editor first. We’ll show and prove it by running through some examples and

Continue reading

Power BI Modulo and Integer-Divide DAX Functions

I thought it’d be interesting to find a way to highlight functions and operators in Power BI that you may haven’t come across before, deeply buried in the menus, or those that you may have seen, but don’t really know what they do. In this tutorial, I’d like to highlight the Power BI Modulo and

Continue reading

Advanced Transformations In Power BI

Let me discuss some advanced transformations in Power BI through the query editor. You may watch the full video of this tutorial at the bottom of this blog. 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

Continue reading