All Blog Posts by year

2024

2024-10-06
-
Mail-Enabled Security Groups explained: how to create and use them in Microsoft 365
2024-03-11
-
The best Power Query and M documentation – Introducing PowerQuery.how

2023

2023-12-29
-
Trace Queries in Excel Power Pivot using SQL Server Profiler
2023-09-15
-
WhatTheFact.BI YouTube channels (yes plural!) are here!
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-04-02
-
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-03-13
-
One-step conditional value replacement in a column in Power Query
2023-02-26
-
Check if a text contains a specific value in DAX
2023-02-26
-
Prüfen, ob ein Text einen bestimmten Wert enthält 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-12-12
-
Meine Erfahrungen von meiner allerersten PASS data community summit 2022
2022-08-12
-
How to create a service principal for power bi
2022-08-12
-
Wie man einen Service Principal für Power BI erstellt
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-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