If you use DAX to flatten Parent-Child hierarchies you will end up with a table that has a static number of columns (like described here). If you need a dynamic (…) Read more
Posts in Category ‘little Tipps&Tricks’
Conditions in FirstN, LastN and other xN-functions in M, PowerBI and Power Query
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
How to store tables longer than 1,1 Mio rows in an Excel-sheet using Power Query and JSON
If you are working Power Query, you might come into a situation where you would like to make tables accessible from outside that file, that are longer than the 1,1 Mio rows (…) Read more
Import Measures from different Tabular Models using DAX Editor
Marco Russo has created a great tool for SSAS tabular that lets you edit measure definitions (which you should read here first if you haven’t done yet). In this article (…) Read more
How to tame Case Sensitivity in Power Query and PowerBI
Have you heard of “Comparer.OrdinalIgnoreCase”? If the answer is “No” (or something similar), you will be very delighted to hear that this is your key to disable case sensitivity in comparing operations. (…) Read more
Universal JSON-opener for Quandl in PowerBI and Excel/Power Query
Today I discovered JSON (…confess) and Quandl. Mates – this is powerful! Here comes just a quick function to automatically expand all columns of a time-series at once: