## DAX : Inventory or Stock Valuation using FIFO

Posted on Dec 3, 2018 in DAX, Power BI

All source files for this article can be downloaded here : A good friend and member of my local Power BI User Group contacted me recently to ask if I might help with a problem he trying to solve in DAX.  He was keen to track the value of items purchased over time in chronological ...

## Fun with DAX – A-Maze-ing DAX

Posted on Nov 26, 2018

Intro: In my younger days, I enjoyed playing computer games and in particular, maze-based games. So for the latest addition to my series of DAX based games, I thought I would have a crack at building a game in Power BI that allowed the user to appear to control a character through a maze to ...

## Quick DAX : Word count

Posted on Oct 13, 2018 in DAX, Power BI

Here is a technique you might consider if you need to split text down to individual words.  This could be used to help count, rank or otherwise aggregate the words in some longer text.  The approach detailed here uses spaces as a delimiter and will not be tripped up if multiple spaces are used between ...

## Fun with DAX – Minesweeper

Posted on Oct 4, 2018 in DAX, Power BI

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 ...

## Fun with DAX – Mission Impossible

Posted on Aug 21, 2018

Further to my recent series of Power BI based games, I thought for this article I would build a version of the popular children’s game, Hangman.  To win the game, you need to guess a hidden word letter by letter, with the user having a number of “chances” with each wrong guess bringing you closer ...

## Quick DAX : Convert to Roman Numerials

Posted on Aug 9, 2018 in DAX, Power BI

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 ...

## Microsoft Business Applications Summit – 2018 Keynote (Live Blog)

Posted on Jul 24, 2018

I have front row seats at the keynote that will begin shortly.  As features and announcements are made, I will update here. The room is massive and filling fast.  I’m sitting with some true legends in right by the stage and there is an electric buzz in the air. And we are underway. Power BI ...

## Fun with DAX – Tic Tac Toe

Posted on Jul 17, 2018 in Power BI

To follow in the spirit of some of my recent blogs, I thought I would have a look to see how feasible it might be to build a Tic Tac Toe game using just DAX and Power BI.  I get pretty close and will detail my approach here in this article.  For starters, here is ...

## Quick DAX : Convert number to binary (and back)

Posted on Jun 27, 2018 in DAX, Power BI

Something that is currently missing in DAX is a native set of functions to perform Bitwise operations.  These can be incredibly useful functions and one, in particular, is the ability to convert a  base10 number to its binary format. Once you have the number in binary format, you can apply logical operations between numbers to ...

## Fun with DAX – Sudoku

Posted on Jun 22, 2018 in DAX, Power BI

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 ...