Why Read My Blog?

I write about various topics related to dashboard design and data visualization, to technical tips for Power BI, Power Query and DAX. I try to keep it interesting and engaging with the help of the Alien (sometimes can be shy).

September 24, 2019

Here's the situation: I have a list of values (text/string). I want to create one single concatenated string based on that list.

June 9, 2019

The alien walks us through a comparison of increases in tourism per country per year. Also go over some Power Query and DAX tips including ALLEXCEPT().

April 26, 2019

Power BI has a somewhat hidden feature you may not have know existed - or maybe you knew about it but haven't given it a thought to try it out (you should!).

April 8, 2019

Why Power Query doesn't give you the option to expand a merged table with both non-aggregate values AND aggregate values. Let's take a look...

November 24, 2018

This is a collection of Power Query / M functions that I've used in the past. I'm using this article as an open collection so that you may benefit from them as

November 17, 2018

Do you feel lost sometimes in Power BI? Don't worry! I compiled together some of the major areas of Power BI, Dax, and Power Query into an all inclusive quick

November 12, 2018

​How do the top 10 companies in GA and their respective tax payment in 2018 line up? Plus, a look at nesting queries within queries.