Tag: Data Transformation

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. How To Access Power BI’s M Language To access the M code, select

Continue reading

Organizing Your Queries Into Groups In Power BI

If you have a big data set and a large number of queries, it is a must to do data cleaning. Some users don’t realize how essential data cleanup is inside the Query Editor. You can easily use the options from the Transform ribbon or simply right-click the columns. There’s absolutely no need to use

Continue reading

Best Practices For Transforming Data In The Query Editor

When you transform your data inside the Query Editor, there are important practices that you need to implement to get the best experience. These are simple tips that can have a big impact on your reports and visualizations. It includes the things that people often take for granted but are essential in getting high-quality analysis

Continue reading