Do you keep getting the error that states The column ______ of the table wasn’t found? It’s because the column names in the source data have changed. The thing is, if we can control the column names in our query, it is much less likely…
We are all neat freaks. Yes, even those people who claim not to be! We can see this in Power BI users all over the world. How do I know? Well, we all want to see equal column widths in a matrix visual. Look at…
As a qualified accountant, I often think about Power BI in terms of financial reporting. When working in this area, the standard method is to show negative numbers in brackets (or parentheses, as you may call them in your part of the world). There is…
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…