Parsing Organizational Hierarchy or Chart of Accounts in Power BI with Parent-child Functions in DAX

Parent-child functions in DAX are very useful for parsing an organizational hierarchy or something like a chart of accounts. Usually, for hierarchies that the number of levels is not determined, you need to use a different method, and parent-child functions in DAX are a big help for that type of hierarchies. In this post, you ...

Read More

Quick DAX : Convert number to binary (and back)

Posted by on Jun 27, 2018 in DAX, Power BI | 2 Comments

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

Fun with DAX – Sudoku

Posted by on Jun 22, 2018 in DAX, Power BI | 3 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

DateAdd vs ParallelPeriod vs SamePeriodLastYear; DAX Time Intelligence Question

Using DAX time intelligence functions for a while; you may ask this question from yourself that what is the difference between functions below; SamePeriodLastYear function vs using ParallelPeriod with Year parameter ParallelPeriod for a month vs DateAdd for a month ago and many other questions that lead to this final question: Which function should be ...

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