DAX dDates table 2.0 | TMDL
Many years ago I made a DAX calendar blogpost. I’ve been using that calendar table for many reports since then. Now it’s on like page 4 of the blog or something and it’s annoying to make all the clicks needed to get to it. Clearly the best solution is...
Using RLS for Dynamic filtering
Yes, you read the title correct. I know you might think “but.. RLS will remove the rows completely, not just filter it out”. Let me just outline the use case before I jump into the creative solution. You have a report. Users look into this report and they’re allowed...
RLS group with DAX
When we talk about RLS, the first thing that comes to mind might be to set rules like “if your username matches this, you can see ‘your own’ data” or we’ll make a rule that simply says “Company = Contoso” and then we have to put people in that...
Generating an Observation-Table with DAX
We all strive for what really matters in life, enriching data, so I understand that I already preach to the choir with this blog post 😉 If you are however in that outlier percent of people with other, weird, interests in life, let me introduce you to what I...
Prompt Buddy Power BI Template
I woke up one morning and had the urge to create a Power BI template for Prompt Buddy. You know how it is. This is not the story of how you install it. The Power BI Template file can be found on GitHub from the link above including installation...
Multiple sources in same Query
I’ve faced this scenario so often, it’s time for a blog post about it! The issue is that sometimes the data I want in my table is split into multiple sources. Here’s a sample example with only 10 rows for simplicity. I have users and meta data on each...
Power BI Template for Chess.com
I recently got pulled into the rabbit hole that is chess and mainly the analytics of it. I’m still a terrible player by all accounts. As I visioned all things you could potentially do with PGN (Portable Game Notation) data, I realized this type of number crunching might be...
Non-linear parameter
I feel like parameters in Power BI are way under utilized! I’m not talking about the ones in Power Query now but rather the ones that used to be named “What-if”, before field parameters were added. Parameters are a great way to allow your report users the ability to...
Creating Popups in Power BI
I had a discussion with my good friend and former colleague Mathilda Bäckman today regarding Power Automate in Power BI. The idea is awesome! You put a button in your report and give the end user the ability to take action with filtered date from the report directly without...
Measure Distance dynamically
Some time ago I had a discussion with a friend of mine about the selection of comparable data. We talked about how schools were compared and expected to achieve the same results of they could be grouped as similar. The problem is that you have to define what parameters...