Let’s say you have a total budget, you want to compare it to your 3 income streams and you want to merge the diagrams below into one. Clearly it’s possible (I haven’t made the final diagram in paint you know) and here’s how it’s done! The issue In Power...

If you’re reading this blog post despite what is possibly the most boring title in the history of blogging, I salut you! Thanks for giving it a try and I’ll do my best to provide something for you that you will have good use for. OK so this idea...

As time travelling is yet to be invented, the dimension of time tends to be rather crucial in most reporting scenarios. I can only imagine the implications time travels will have on the BI business!“As you can see the trend is going upwards! This is great!”“Yesterday I showed you...

I like to consider myself a good listener. To music, that is. Spotify is almost always on regardless if I’m working, driving, cooking or working out. I recently figured there must be a ton of data that Spotify has collected for me! I mean, they do come up with...

From personal experience, I’d say that the Servicedesk is most likely the most data driven group in IT. Everything is measured, especially the ticket system. How many cases do we have, how many requests versus incidents, who have completed the most tickets last week, last month, this year… The...

From time to time, I stumble upon data that have a starting and an ending time. It could be opportunities in a CRM system, time between an email arrived in you mailbox until it was responded to or a very common one; A service desk case. Calculating the amount...

I recently came into possession of a dataset of weather data from a friend of mine. Just as I am one of those normal friends who get’s thrilled when presented with 1,2 million rows of raw temperature data, so is he a very normal friend who gets thrilled by...

I recently made a backlog in a report for a customer and figured that this is the kind of stuff the internet could make use of too! I’ve created a sample PBIX-file for anyone to download and copy coding samples from to save some time when creating your backlog...

I recently set up a Github repository for my digital Give aways and I figured this would also be a good place to store a sample file for a DAX formula I recently was using in a customer report and then a colleague said “Hey this would be great...

Ever heard that less is more? You can’t see the forest due to all the trees? This happens in Power BI all the time and fortunately there is this great solution called grouping! This is a short post about the feature and 2 examples where I like to use...