Today I discovered that we can use conditions in many of the N-selecting functions where one/I would normally expect just a number-expression for the N: Table.RemoveFirstN( table as table, optional countOrCondition as any) (…) Read more
Posts Tagged ‘M’
Comfort Functions for Easy Profit & Loss statements in Power BI and Excel – Part2
Here comes some long awaited comfort functions for part 2 of my easy P&L series. In the first section I’ve presented the general principle on how to work with a (…) Read more
Dynamic & bulk type transformation in Power Query, Power BI and M
This is just a quick code-share-of-the-day of different scenarios for dynamic type transformation of multiple columns at once. The syntax to transform the format of 2 columns (“Column1” and “Column2”) in (…) Read more
Advanced type detection in Power BI and Power Query: Table.ClassifyMixedColumnTypes
This is not a proper blogpost, just a quick share of a function I’ve created today which I think will be very useful for others as well: Automatic type detection will (…) Read more
How to analyse M-functions step-by-step?
This is a quick tutorial on how to analyse M-functions step-by-step. Queries, that have been transformed into a function (1) can be invoked in the query-editor (2) and they will then return (…) Read more
Multiple replacements or translations in Power BI and Power Query
A common task when cleaning data is to perform multiple replacements at once. When dealing with “translation tables” you might have come across Chris Webb’s solution using List.Generate to deal with this. (…) Read more