Fun with DAX – Minesweeper

Posted by on Oct 4, 2018 in DAX, Power BI | 6 Comments

The latest addition to my recent series of DAX based games is the classic Minesweeper game.  This is the game where you are presented with a 9 x 9 matrix of squares.  There are 10 hidden mines and you can either step on a square or place a flag where you think there might be ...

Read More

Quick DAX : Convert to Roman Numerials

Posted by on Aug 9, 2018 in DAX, Power BI | No Comments

One of the biggest holes in DAX today is the lack of a native function that allows you to convert a decimal number to its roman number equivalent.  Excel has a ROMAN() function so I thought it was about time to share one approach to converting decimal numbers to Roman.  I can feel a collective ...

Read More

Composite Model; DirectQuery and Import Data Combined; Evolution Begins in Power BI

With the new announcement of Power BI Desktop release of July 2018 at Business Applications Summit, the break-through feature is the ability to create a composite model. Now you can have part of your Power BI model to come directly from a data source, and another part to be imported. Along with this change, you ...

Read More