UseRelationship or Role-Playing Dimension; Dealing with Inactive Relationships in Power BI

In a Power BI model, relationships are important for passing filters, filter propagates through relationships. However, sometimes you create the relationship between two tables, and the relationship is a dashed line. In this post, I’ll explain to you everything you need to know about a dashed relationship, or as it called Inactive relationship. I will ...

Read More

Quick DAX : Word count

Posted by on Oct 13, 2018 in DAX, Power BI | 9 Comments

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

Fun with DAX – Minesweeper

Posted by on Oct 4, 2018 in DAX, Power BI | 6 Comments

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

Quick DAX : Convert to Roman Numerials

Posted by on Aug 9, 2018 in DAX, Power BI | No Comments

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

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