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

Introducing Lingo

2018-04-18 Mike Carlo

In April of 2018 the Microsoft team released the ability to edit the Linguistic schema in Power BI desktop. For those who are not aware of the linguistics, essentially, this is the code that drives […]

Crazy Table Gymnastics – Part 2 – Build Support Materials

2018-02-21 Mike Carlo

This is part 2 in the 3 part series on developing super cool tables using some fancy measures. In part 1 we walked through how to build a table that uses an un-pivoted data source […]

Crazy Table Gymnastics – Part 1 – Dynamic Column Categories

2018-02-14 Mike Carlo

When I teach Power BI to new users, there are typically questions about how to get Power BI to act more like Pivot Tables in Excel. Through my discussions, two key pieces of functionality stand […]

Creating A DAX Calendar

2017-11-01 Mike Carlo

There are many cases when you will need to create a date table within Power BI desktop. This could be as simple as creating a master date table or more complex such as creating a […]

Power BI World Tour 2017 – Chicago – Top Tips

2017-10-11 Mike Carlo

To everyone who was able to attend the Power BI World Tour 2017, Thank you! It has been a pleasure presenting my favorite tips and trips. This post consolidates all the links for each topic […]

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