Skip to content

Ville Gullstrand

Generating an Observation-Table with DAX

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 mean by “Observation Table” and why […]

Prompt Buddy Power BI Template

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 instructions. This is the story of […]

Multiple sources in same Query

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 user. All good, right? Wrong. It’s […]

Power BI Template for Chess.com

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 better suited for Notebooks and Lakehouses […]

Non-linear parameter

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 simulate outcomes! I have a couple […]

Creating Popups in Power BI

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 having to export any lists or […]