Some time ago I published a function that extracts all M-code from Power BI (.pbix)-files. Today I publish the pendant to Bulk-extract Power Query M-code from multiple Excel-files at once. (…) Read more
Posts Tagged ‘M’
Types in PowerQuery cannot be compared and a Type.AsText function
Sometimes I need to retrieve the textual representation of a type in Power Query and I’m using a fairly verbose function that I’ve stolen ages ago (I believe it was (…) Read more
Screenshot tutorial: Add a column with custom function code in Power Query
The following steps show how to create a new column in a table using existing custom function code. This works in Power BI as well as in Power Query in (…) Read more
Writing data to GitHub using Power Query only
You shouldn’t do it … Generally it’s a very bad idea to execute commands in Power Query that write out data to a source, as these commands might be executed (…) Read more
Get full Time Activity data from QuickBooks into Power BI
Problem As per the time of writing, the native QuickBooks connector in Power BI has some shortcomings for the Time Activity-data: It will not return employee details (so you will (…) Read more
Unravel cumulative totals to their initial elements in Power BI and Power Query
Recently I came across an interesting request where someone wanted to un-cumulate their quarterly YTD-figures (green) into their single quarters values (red) like so (“Unravel cumulative totals”): Task Method To (…) Read more