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 Read more about DAX : Inventory or Stock Valuation using FIFO[…]
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 Read more about Fun with DAX – A-Maze-ing DAX[…]
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 Read more about Quick DAX : Word count[…]
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 about Fun with DAX – Minesweeper[…]
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 Read more about Fun with DAX – Mission Impossible[…]
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 about Quick DAX : Convert to Roman Numerials[…]
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 Read more about Microsoft Business Applications Summit – 2018 Keynote (Live Blog)[…]
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 Read more about Fun with DAX – Tic Tac Toe[…]
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 Read more about Quick DAX : Convert number to binary (and back)[…]
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 about Fun with DAX – Sudoku[…]