DAX Expressions Archives -

All Columns have Data Types in DAX, Or do they?

2021-12-07 Greg Baldini

To say this another way. Not all columns have datatypes in DAX, specifically speaking to using dynamic ranking with an “Other” category. Let me explain. The Tabular model is comprised of tables with typed columns. […]

Santa Loves Power BI and R

2016-12-23 Mike Carlo

This past week I was talking with the big guy up north, jolly old fella, and the discussion came up about his toy production levels. Santa was complaining about how hard it was to measure […]

Measures – Year Over Year Percent Change

2016-12-05 Mike Carlo

This tutorial is a variation on the month to month percent change tutorial. This specific exploration in year over year performance was born out of reviewing my google analytics information. The specific analysis question I […]

Pareto Charting in PowerBI

2016-10-17 Mike Carlo

The Pareto chart is a handy visual, but is not so easy to build in either excel or PowerBI. In a Pareto chart, information is provided about an individual product or category as a bar, and […]

Map with Data Labels in R

2016-10-10 Mike Carlo

Mapping is one of the better features of PowerBI. It is one of the more distinguishing feature differences between Excel and PowerBI. You can produce a map inside an excel document using Bing maps, however, the […]

Fixing Measure Madness

2016-10-04 Mike Carlo

Often times when you’re working with large data models you will have multiple tables with many relationships. It could be complex maybe you’ve seen something like the following: Once all the tables have been loaded […]

Digging Deeper with R Visuals for PowerBI

2016-09-21 Mike Carlo

Back by popular demand, we have another great tutorial on using R visuals. There are a number of amazing visuals that have been supplied with the PowerBI desktop tool. However, there are some limitations. For […]

Measures – Intelligent Card Visual – Using DAX

2016-07-28 Mike Carlo

As I have been exploring PowerBI and building dashboards I have noticed that often the visuals can obscure your data. As you click on different visuals there is a need to highlight different pieces of […]

Measures – Month to Month Percent Change

2016-07-14 Mike Carlo

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 […]

Measures – Dynamic Percent Change – Using DAX

2016-06-10 Mike Carlo

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 […]