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

## Quick DAX: Use GENERATESERIES to create Time buckets

Posted on Jun 21, 2018 in DAX, Power BI

A not so obvious use of the recently added GENERATESERIES function to use it to generate time buckets.  The more common use of this function is to generate series of numbers, but it works just as well with Time based data. Say you want to create a data table with rows that represent time periods.  ...

## Fun with DAX – Blackjack Game

Posted on Jun 8, 2018 in DAX, Power BI

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

## DAX : Convert Number into Month Name

Posted on May 19, 2018 in DAX

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

## Fun with DAX – Compressing Numeric Sequences to Text

Posted on May 15, 2018 in DAX, Power BI

A recent post on the Power BI community website asked if it was possible to compress a group of numbers into text that described the sequential ranges contained within the numbers. This might be a group of values such as 1, 2, 3, 4, 7, 8, 9, 12, 13:  (note there are gaps) with the ...