-
This is a quick hack to build many-to-many relationships in Excel data model even though they are not supported out of the box. Create intermediate calculated table and use DAX to fill it with unique values from related columns on both sides of the relationship: EVALUATE FILTER( DISTINCT( UNION( VALUES … -
Excel as a CSV editor (with VBA)
One might think that Excel is a decent CSV editor as it is, but it's not. It is a very capable CSV reader, I do not dispute that. When it comes to writing though, Excel does not match what you'd expect from a mature application: It might change the delimiter … -
Expanding Power Query standard library - introducing LibPQ
Power Query formula language (also known as M language) is a very capable yet not very flexible tool. It lacks some features taken for granted by developers who are used to other programming languages such as compatibility with version control systems, extensibility by third-party libraries, etc. That is why I … -
Loops in Power Query M language
Power Query Formula Language (also known as M language) is sometimes difficult to get your head around. This article explains how someone familiar with loops in other programming languages can approach the same concept in M language. First of all let's look at the definition given by Microsoft: The Power …