English
- Deutsch

WhatTheFact_Logo_Transparent_353x76px

Home
All Blog Posts
Code Snippets
Talks
About me

Menu

Home
All Blog Posts
Code Snippets
Talks
About me

All Blog Posts by year

2023

2023-07-16
-
Easy week over week comparison in Power BI with the new OFFSET function

2023-06-04
-
Awarded as Microsoft MVP 2023 in Data Platform

2023-04-16
-
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

2023-03-28
-
One-step conditional value replacement in a column in Power Query

2023-03-13
-
The ultimate guide to date table relationships – understand relationships with a date column, an integer column and “mark as date table” in Power BI correctly

2023-02-26
-
Check if a text contains a specific value in DAX

2023-02-20
-
How to block other people from overriding your dataset in Power BI (and why you might not want to do that)

2023-01-29
-
wtFact-February is coming! Get ready for my 20 best short Power BI tips!

2022

2022-12-12
-
My experiences from my very first PASS data community summit 2022

2022-08-12
-
How to create a service principal for power bi

2022-07-10
-
Persisting temporary accessible data via Power BI Datamarts with the example of Power BI Activity Logs

2022-04-10
-
Loading Web Data into Power BI Service without Using a Gateway

2022-03-20
-
What are the strange symbols in a Power BI relationship? All you have to know about weak or limited relationships

2022-01-16
-
Change your slicer easily from OR to AND logic in Power BI

2021

2021-11-07
-
Power BI Premium Gen2 is here – everything you need to know about it

2021-10-17
-
Use measure or virtual table as filter for CALCULATE

2021-09-04
-
Reporting for Everyone – Create accessible Power BI reports in just a few steps

2021-08-29
-
Display websites within Power BI dynamically

2021-08-14
-
New notation for Date or DateTime format in Power BI

2021-07-27
-
Change formatting of each individual value dynamically with Calculation Groups

2021-07-15
-
My Power BI and Power Query code snippets are moving to GitHub

2021-07-04
-
Add a single value parameter for any column

2021-06-27
-
Why is it sometimes not possible to select the exact number in the what-if parameter and how can this be solved?

2021-06-11
-
Replace data sources in Power Query with published Power BI dataset

2021-05-30
-
How can I export the underlying data in Power BI?

2021-05-23
-
COVID-19 latest vaccination statistics now available for whole Switzerland on impfstand.ch

2021-04-23
-
COVID-19 current vaccination numbers for the canton of Basel-Stadt, Switzerland

2021-04-18
-
Trigger automated workflows directly and with filter context in Power BI Report with Power Automate Visual

2021-04-11
-
Automatically filter report on actual date with calculated column and with measure

2021-03-21
-
Automation in Power BI – Format all measures, replace text, set default summarization and more

2021-03-13
-
What is a Measure table and how can I create it properly

2021-02-06
-
Understanding Power BI Embedded with Source Code and Contoso Example Portal

2021-01-09
-
Calculate ISO 8601 week in Power Query

2021-01-03
-
Calculate ISO 8601 week in DAX with hidden parameter

2020

2020-12-20
-
Power BI Composite Model V2 – the missing part between Self-Service and Goverened BI is in Preview

2020-12-05
-
Tip for your daily work – Do you already know Microsoft PowerToys and the Color Picker?

2020-11-13
-
Display DAX Measures in a Matrix on Rows

2020-11-08
-
Integrate Power BI Report with complete interactivity in OneNote

2020-11-01
-
Convert UNIX Timestamp to DATE or DATETIME format in Power BI

2020-10-25
-
Multilingual reports in Power BI

2020-10-17
-
Using enterprise or custom fonts in Power BI

2020-10-11
-
How do I get an older version of Power BI Desktop?

2020-10-06
-
My frequently used Power BI snippets

2020-10-02
-
Combine multiple tables with UNION / UNION ALL in SQL Server, APPEND in Power Query or UNION in DAX

2020-09-28
-
Load files with changing names from folders with changing names into Power Query

2020-09-23
-
Announcement: Power BI Premium per user coming soon

2020-09-21
-
Register now, Microsoft Ignite 2020 takes place virtually and free of charge

2020-09-18
-
Dynamic scaling of a measure in Power BI with DAX

2020-09-15
-
That’s one giant leap for me, one small step for mankind

English
Deutsch

Datenschutzerklärung
Impressum

Menu

Datenschutzerklärung
Impressum

Wait!

Follow me on LinkedIn and you’ll gain access to valuable insights, expert tips, and industry updates related to Power BI. Stay ahead of the curve and supercharge your analytics skills today!

Supercharge your Power BI skills!