Fun with DAX – Sudoku

Posted by on Jun 22, 2018 in DAX, Power BI | No Comments

Carrying on from my recent article on how to build a game of Blackjack using Power BI and DAX, this time I thought I would see if I could build a fully playable game of Sudoku. A big thanks to my good friend Tom Martins over at minceddata  for giving me the idea. The end result ...

Read More

Fun with DAX – Blackjack Game

Posted by on Jun 8, 2018 in DAX, Power BI | 3 Comments

I thought it might be fun to try something a little different with this blog and use a combination of bookmarks with a little DAX magic to come up with a game that plays a hand of Blackjack.  Power BI and DAX are not the ideal engine to build a game of Blackjack with, but ...

Read More

DAX : Convert Number into Month Name

Posted by on May 19, 2018 in DAX | 3 Comments

I sometimes see requests asking how to convert a number between 1 and 12 into a month name such as “Jan” or “February. The most common solution I see offered is along the lines of a SWITCH statement that lists 12 conditions (one for each month).   This works, but can also be done using existing ...

Read More