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 in Category ‘Power BI’
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
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