Power BI, Excel and Visio walks into a bar…

They all hit their heads on said bar. After that they sat down to talk. Excel bragged about the cool things it could do. “Behold, as I goal seek certain input for a desired output” he said. He headed into the Data tab and selected Goal seek. With the...

“Who did it?”

These type of questions always come. “How many of my users did this?”, “On how many days did we do that” or simply “How many of my users where active?”. Instead of knowing how much each user did of what, we eventually tend to want to know how many...

Taking control and automating your surveys

In many organizations today there is a need to collect survey data. I’ve seen numerous examples of how this can be done and most of the time it involves some kind of automated email sent out with a link in hopes of your subjects decide to deposit a few...

Machine Learning and Power BI

Everyone seems to be talking about ChatGPT and similar AI solutions now in the beginning of 2023, so I figured I’ll share some thoughts on the machine learning features currently built into Power BI! I should however clarify that these are Premium functions in Power BI. To kick it...

Power BI and Power Automate

I consider myself a #PowerAddict, meaning I’m a nerd throughout the whole PowerPlatform and not just Power BI. You see, everything is connected! You can leverage PowerApps to get your input to datasets, measure it in Power BI to filter out valuable insights and act on these insights automatically...

DAX magic with Selectedvalue

I was recently asked to make a calculation in Power BI and I figured this will make a good blog post for others to learn from as well. OK so the idea is that we have a table with values over dates. We want to accumulate these values by...

Nested SUMX for What-If scenarios in DAX

Did you get goose bumps reading that title? If so, I obligated to refer you to my psychiatrist as this is apparently not normal. If you, like me, don’t really care and still think it’s really cool and you want to find out more, read on! In this blog...

Bayes theorem in Power BI

I’ve been following Veritasium on Youtube for some time. It’s made by Derek Muller who is really awesome att explaining science! Back in 2017 he made this video on Bayes Theorem and while looking through his older videos I stumbled upon it. It’s only 10 minutes long so you...

Scheduled refreshes from files

From time to time you might want to use an Excel or CSV file as the source for your Power BI reporting. The downside of doing so is that if you specify a local file as a source, the Power BI Service wont know how to access it after...

Emails to Team chats | Give away

Want to skip right to getting your hands on a Power BI Report and play? Click here to download the Power BI template from GitHub and get started right away. Backstory “This meeting could have been an email” This is what I used to say at least. These days...