A few days ago, something very special happened in my life. I received the legendary e-mail from Microsoft, that I was awarded Microsoft Most Valuable Professional or MVP for 2023!: What is a Microsoft MVP Before we dive into the details, let’s address the question that may be on your mind: What exactly is a…

When you’re preparing your data in Power Query, you might come to the point where you have to exclude rows in one table, that exist in another table. An example would be if in the sales table you want to exclude rows from business customers or rows from any kind of “black list”. In SQL…

If you work in analytics or business intelligence, you are probably already familiar with a date dimension, since almost every analysis has a reference to a date. But although nearly every data model has a date table, there is quite some confusion about the details. Should I use the column from the type date for…

When you’re working a lot with Power Query, you will sooner or later have to replace values in a column, based on some conditions. Unfortunately, there is no step for that in the Power Query editor. Usually you have to add a conditional column and then remove the old column and rename the newly created…

Mussten Sie schon einmal prüfen, ob ein Text einen bestimmten Wert enthält? Dieses Thema mag zwar recht banal erscheinen, aber es ist eines, das mir bei meiner eigenen Arbeit immer wieder begegnet ist. Und ich bin sicher, dass es vielen anderen auch so geht.In diesem kurzen Artikel werden wir untersuchen, wie man diese Situation mit…