In this blogpost I show you my M-Python-function that I use to export data from Power BI to csv files (Export Python). Why Python? I prefer it to R mostly (…) Read more
Posts Tagged ‘Power Query’
Improved Text.SplitAny – function for Power BI and Power Query
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
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