If you are not in the US, chances are that your organization works with a calendar based on the ISO 8601 week numbering system. In the ISO standard, weeks…
There are many ways to create a dynamic report in Power BI. A lot of the visuals that are available in Power BI also have a conditional formatting possibility to…
When analyzing large amounts of data, we are often interested in trends and correlations. One of the most basic methods to research these, is linear regression. Linear regression is a…
The DAX function ALLSELECTED is a powerful function that accomplishes something that cannot be done otherwise. The simple version of what ALLSELECTED does, is this: like other ALL functions,…
In this third blog about achieving a different mindset when you want to change your business tools from Excel to Power BI. In the first blog I wrote about the…
In this second blog about achieving a different mindset when you want to change business tools, I want to talk about the creating an extra numeric column as relation column…
This blog is all about achieving a different mindset when you want to change business tools. If you used to work with Excel and want to take the path of…
This article is a follow-up to the AutoExists introductory post and one with an example on time intelligence based on workdays. In the latter, we created the month-to-date chart below,…
I recently delivered a training about data awareness. Strangely enough data awareness is not a common practice within organizations. To my great surprise the impact of data on their business…
In this post, I show an approach to non-standard time intelligence analysis. This is, in fact, the second article on AutoExist. In the first, I explained the general principle of…