Today I’ll present an adjustment to the Text.SplitAny – function in Power BI’s query editor or Power Query. The native function takes a string as an input and splits the (…) Read more
Why Power BI isn’t suitable for Financial Statements (… currently … hopefully …)
!! This is a clickbait post to get your vote for some missing features in Power BI !! Although this might not be what the inventors of Power BI had (…) Read more
Create list of accounts from NAV account schedules or COA totaling syntax
In this blogpost I’ll show you how to create a list of account numbers from the totalling syntax that you find in Dynamics NAV account schedules or chart of accounts (…) Read more
Return all occurrences of text between delimiters in Power BI and Power Query
The M-function Text.BetweenDelimiters does what it says and returns the text between 2 delimiters in the query editor of Power BI and Power Query. But irrespective of its optional arguments (…) Read more
Transform text with exceptions in Power BI and Power Query
Recently I picked up an interesting request to transform text with exceptions: Transform the words in a column to proper case, but keep certain keywords like in a defined list. (…) Read more
Memory efficient clustered running total in Power BI
Today I want to share a scenario where a running total calculation in the query editor saved a model that run out of memory when done with DAX: Problem The (…) Read more