Most data problems in Power Query can be solved using the UI, and even more can be resolved by slightly editing the M code generated by the UI. Thus, if your data is not excessively messy and your transformations aren’t too intricate, you may not require extensive M knowledge. However, if you invest time in learning M, you can unlock incredible possibilities!

Learning M language is going to be advantageous for anyone who works with data and wants to efficiently manipulate, clean and transform large and complex data sets. In this video, Brian is going to demonstrate exactly why that is Continue reading “How To Validate Data Against Online Lists Using M” →

Measures are an essential part of creating meaningful data visualizations in Power BI, as they allow analysts to define calculations and metrics based on their data. However, making changes to measures can be a tedious process, especially if the data model is complex or the calculations involve multiple steps.

When changing the formula for a measure, you may need to modify multiple components of the data model and visualization to ensure the changes are reflected accurately. This can involve navigating through multiple menus and interfaces in Power BI, which can be time-consuming and error-prone. In this video, Brian will show how Continue reading “How To Quickly Changing Multiple Measures At Once In Power BI” →

Power BI can be extremely useful in managing supply chain data by providing powerful visualization and analytics capabilities that enable users to gain insights into their supply chain processes. Users can use Power BI to monitor and analyze inventory levels, track supplier performance, and identify supply chain bottlenecks. Additionally, users can leverage machine learning algorithms to forecast demand, optimize inventory levels, and reduce lead times.

By using Power BI, supply chain managers can make informed decisions that improve supply chain efficiency, reduce costs, and increase customer satisfaction. In this video, Sam will demonstrate how you can effectively manage supply chain Continue reading “How To Manage Supply Chain Data With Power BI [2023 Update]” →

Paginated reports are incredibly useful in the Power BI service because they provide a way to create pixel-perfect, printable reports that look great regardless of the device or screen size. These reports can be exported to a variety of formats, including PDF, Excel, and CSV, making them ideal for sharing with stakeholders who prefer to work with data offline.

However, creating paginated reports can be tricky, especially if you’re starting with an already published data set. One of the most common mistakes people make is assuming that the report layout will be identical to the visualizations in the original report. This Continue reading “How To Create A Paginated Report In Power BI Service From A Published Data Set” →

Power BI users often encounter the requirement of calculating averages per day when dealing with time-based data such as sales, web traffic, or social media activity. This calculation helps to provide a more accurate representation of performance trends and fluctuations over time, especially when compared to absolute values. In this tutorial, Sam will show how you can easily calculate averages per day using DAX in Power BI.

*****Video Details*****
00:00 Introduction
0:29 Data model
00:45 Total sales by customer
01:45 Averages sales per day by customer
03:10 Changing the time frame
03:48 Recap of the process
04:55 Applying the same formula against different dimensions

***** Learning Power BI? ***** Continue reading “How To Calculate Averages Per Day In Power BI [2023 Update]” →

Have you ever watched a video, perhaps a tutorial, and you just want to badly try out and practice with the featured data set? In this video, Brian is going to show how you can easily capture and clean on-screen data, apply two powerful functions for reshaping stacked data, and demonstrate some cool aspects of how pivoting works all in under 9 minutes!

*****Video Details*****
00:00 Introduction
00:45 Blackbox extension
01:10 Pasting the data
02:04 Integer-Divide
03:34 Pivoting data
04:47 Cleaning nulls
06:22 Modulo

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – www.enterprisedna.co/courses/ultimate-beginners-guide-to-dax
FREE Continue reading “How To Capture and Clean On-Screen Data To Use In Power BI” →