Building Date Table from Scratch
Recently at work I’ve been working with a number of large data warehouses with time series data. Often when working on such data you need […]
Data Modeling
Loading Data From Folder
Let me setup a scenario for you. You get a data file from an automated system, it has the same number of columns but the […]
Measures – Dynamic Percent Change – Using DAX
This tutorial will produce a measure that will dynamically calculate a percent change every time an item is selected in a visual. The previous tutorial […]
Query Editor – Editing M Code
In this tutorial we’ll learn how to copy and paste queries to and from the Query Editor. When your working in Power BI Desktop often […]
Measures – Calculating a Sum
Often there are times when you will want to display a totals. Using measures to calculate a total are extremely easy to use. The power […]
From Wikipedia to a Colorful Map
For this tutorial we are going to get some real data from the web. One of the easiest sources to acquire information from is Wikipedia. […]
Manually Enter Data
There are often times when you need a small data set in order to make a visual behave exactly how you want it to. This […]
Query Settings – Fixing a Missing File
One of the most important concepts to learn within Power BI Desktop is how to build a Data Model. Note: In simple terms the Data […]