With all the functions in Power Query (over 700), it’s hard to believe there are any missing. However, there is no function for List.Unique. I know what the clever ones amongst you will say… “It’s called List.Distinct”. The thing is, unique and distinct are not… Read More »List.Unique is missing: 2 easy to use alternatives
OK, let’s face facts. A lot of data exported from IT systems contain column names intended to be computer-readable, but only partially human-readable. As a result, column names are often in camel case or filled with underscores. We want fully human-readable column names in the… Read More »Easy way to auto rename columns in Power Query
People in finance often need to use foreign exchange rates in their calculations. Since Power BI is the ultimate automated reporting solution, it makes sense to find a way to get FX rates into Power BI as easily as possible. Table of Contents Get FX… Read More »Get FX rates into Power BI: Amazing custom function
If data comes to Power BI through downloaded CSV/Excel files or the internet, we often encounter unwanted spaces within the text. However, we rarely want these extra spaces within Power BI. Therefore, in this post, we are looking at how to remove spaces in Power… Read More »Remove spaces in Power Query (the easy way)