I recently came across a post in Linkedin about a script that performs Pattern Matching or “Fuzzy Lookup” within TSQL. The Script was definitely an elegant solution to […]
Using Bookmarks in PowerBI
PowerBI is a robust reporting tool that has a number of easy to use and configurable options when it comes to reporting. One of the most frequently used […]
Using Time Series DAX functions in PowerBI
Recently at a training I was asked how to implement DAX Time Series functions like parallel period and YTD in PowerBI. I always assumed that I had something […]
PowerBI Calendar control
A client recently asked for a calendar layout within the report. This is one place where I feel PowerBI seems to lacking significantly since there are no native […]
PowerBI Connection error when logging into the cloud site
Recently in a training we encountered the below issue. I guess this will only occur in cases like a training room. Essentials the error message we get when […]
Charting controls: – Things to keep in mind – Part 2
In this second part of the series on charting controls we take a look at a few lesser known charting controls. You can view the first part of […]
Charting controls: – Things to keep in mind
I often do a number of trainings on MSBI and PowerBI and one of the tasks we do during the course is “I would ask all participants to […]
Loading multiple files into Power Query/ PowerBI
In this post we cover how to work with multiple files of type CSV when loading into Power Query. Very often we have a set of data provided […]
DAX and Date Time or Time Intelligence Analytics
One the best parts of using analytics engines are their ability to understand dates and other types of hierarchies. As human being we use time as a core […]
Brand new video on PowerBI
A brand new video on PowerBI, with a quick introduction on the tools. After which we create a report and use the basic features. https://youtu.be/tPrHkbgSj10