Mike Carlo, Author at - Page 13 of 14

Measures – Month to Month Percent Change

2016-07-14 Mike Carlo 50

I had an interesting comment come up in conversation about how to calculate a percent change within a time series data set. For this instance we have data of employee badges that have been scanned […]

Loading Data From Folder

2016-06-16 Mike Carlo 37

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 data changes for every new file. Being the data savvy […]

Measures – Dynamic Percent Change – Using DAX

2016-06-10 Mike Carlo 20

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 can be found here. In the previous tutorial we calculated […]

Measures – Dynamic CAGR Calculation in DAX

2016-05-27 Mike Carlo 10

This tutorial walks through calculating a dynamic Compound Annual Growth Rate (CAGR). By dynamic we mean as you select different items on a bar chart for example the CAGR calculation will update to reveal the […]

Query Editor – Editing M Code

2016-05-19 Mike Carlo 2

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 you will need to share and model the data before […]

Measures – Calculating a Sum

2016-05-07 Mike Carlo 3

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 of using a measure is when you are slicing and […]

Measures – Calculating % Change

2016-05-02 Mike Carlo 12

In our last post we built our first measure to make calculated buckets for our data, found here. For this tutorial we will explore the power making measures using Data Analysis Expressions (DAX). When starting […]

Power BI Histogram with Bins – Includes DAX

2016-04-27 Mike Carlo 2

Alright to start this Tutorial off right we are going to incorporate the new feature released this spring from Power BI, called publish to web. Below you can view last weeks tutorial and interact with […]

From Wikipedia to a Colorful Map

2016-04-20 Mike Carlo 1

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. I will caveat this by saying, it is easy to […]

Map it, Map it Real Good

2016-04-14 Mike Carlo 4

This tutorial is a real simple mapping exercise. I was talking with a colleague today about Power BI and I was challenged to map something using latitude and longitude. I had played with mapping before […]