Tag: Data Transformation

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

Creating A Date Table In Power BI

The importance of creating a date table in Power BI is something that people often miss, especially in the Enterprise DNA forum. You may watch the full video of this tutorial at the bottom of this blog. Although it’s common to have a date column in your sales tables and transaction tables, that won’t be

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. You may watch the full video of this tutorial at the bottom of this blog. The query editor allows you to clean up your data and transform it from its rawest form. Although it allows you to do some

Continue reading

How Query Dependencies Work In Power BI

Query Dependencies In Power BI

For this tutorial, we are going to delve deeper and understand how Query Dependencies work in Power BI. Query Dependencies show you how the queries are linked together inside Power BI. You can see which queries depend on other queries or tables. This is useful when you plan to do a lot of data transformations

Continue reading

Beginners’ Guide To The M Code In Power BI

This tutorial will help you understand more about the M code found inside the Advanced Editor. Some people prefer to call it “M formula language” or “M function.” You can use it to filter and combine your data from multiple data sources. DOWNLOAD FREE RESOURCE HERE How To Access Power BI’s M Language To access

Continue reading