You can now download a new version of my Power BI Cleaner tool that finally covers usage of DAX expressions in Calculation Groups as well. For an introduction into this (…) Read more
Guest Post: Using List.Accumulate for Input/Output Genealogy
Foreword from Imke: Pat Mahoney is a very active fellow super user in the Power BI community and has a very strong interest in all things Power Query. He also (…) Read more
Workaround to connect to Power BI dataflows from Power Query in Excel
Currently, we cannot connect to Power BI dataflows from Excel Power Query. And as we also cannot use custom connectors in there, we need a different alternative. I’m going to (…) Read more
Exception reporting and management for missing fuzzy matches in Power BI
In a previous article I have described how to use Fuzzy merge to match misspelled data to valid categories. With the sample data at hand, all values could be matched (…) Read more
Extract only letters from a mixed string in Power Query and Power BI
This is a quick method about extracting only letters from a string. It is part of the Week2 “Preppin’ data” challenge. Task for extracting letters from a string Image you (…) Read more
Clean up or harmonize mis- or differently spelled category data with Power Query
A typical problem with data that has been created by manual entries is that category values are often misspelled or missed. So in this article I’m showing a very powerful (…) Read more