Trace Queries in Excel Power Pivot using SQL Server Profiler

December 29, 2023
Denis Selimovic
Power Pivotcomment 3Created with Sketch Beta.0 comments

Although most of the articles in this blog are dealing with Power BI, we should not forget that the technology of Power BI is also available in Excel. There it’s just called Power Pivot, but behind the different user interface, it’s more or less the same as Power BI. Power Pivot is Power BI in…

Read more

WhatTheFact.BI YouTube channels (yes plural!) are here!

September 15, 2023
Denis Selimovic
Blogcomment 3Created with Sketch Beta.0 comments

I am thrilled to share some big news that’s been in the works for a while now.As part of our commitment to provide you with the best Power BI resources and tutorials, we’re expanding our horizons by launching not one, but TWO YouTube channels! Why another YouTube channel? As you might have realized, there were…

Read more

Easy week over week comparison in Power BI with the new OFFSET function

July 16, 2023
Denis Selimovic
DAXcomment 3Created with Sketch Beta.5 comments

In data analysis a common requirement is to compare your values of one week to the ones of the previous week. Such a week over week comparison gives important insights as you compare a bigger timeframe and can – without waiting for months – still see where the trend is going. How to handle the…

Read more

Awarded as Microsoft MVP 2023 in Data Platform

June 4, 2023
Denis Selimovic
Microsoft MVPcomment 3Created with Sketch Beta.0 comments

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…

Read more

Remove rows that exist in another table in Power Query – How to use an Anti-Join (Not-In-Join) for data cleansing in Power BI

April 16, 2023
Denis Selimovic
Power Query / Mcomment 3Created with Sketch Beta.0 comments

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…

Read more