One-step conditional value replacement in a column in Power Query

March 28, 2023
Denis Selimovic
Power Query / Mcomment 3Created with Sketch Beta.6 comments

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…

Read more

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

March 13, 2023
Denis Selimovic
Data model, DAXcomment 3Created with Sketch Beta.2 comments

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…

Read more

Check if a text contains a specific value in DAX

February 26, 2023
Denis Selimovic
DAXcomment 3Created with Sketch Beta.2 comments

Did you ever need to check if a certain text contains a specific value? While this may seem like a small topic, it’s one that I have come across multiple times in my own work, and I’m sure many others have as well.In this short article, we’ll explore how to handle this situation using DAX.…

Read more

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

February 20, 2023
Denis Selimovic
Administrationcomment 3Created with Sketch Beta.0 comments

When you publish a dataset on the Power BI service, anyone with the proper access to it can make changes to the data model. Most of the times, you want people to cooperate and work together. But there are some cases, where you don’t want to allow others to override your dataset for some reason.…

Read more

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

January 29, 2023
Denis Selimovic
Power BIcomment 3Created with Sketch Beta.0 comments

It’s almost February and in the next days I will start a small series on LinkedIn.On every weekday, I will share a small tip for the main Power BI areas. The 20 best tips in a short version on LinkedIn Many times when I see issues with Power BI, the answers are going back to…

Read more