Collect/Analyze/Automate with the Power Platform

Stephanie and I are data people. We excel at taking loads of unstructured data and making it intelligible (see what I did there?!). Do we want to be working with unstructured data? Is Excel a data collection tool? Or better yet, is Excel a database? In theory the answer to all of these questions is… Continue reading Collect/Analyze/Automate with the Power Platform

Create an Interactive Legend in your Power BI Map

Mapping in Power BI can be super simple. Drop a field with a location in it, add a value, and you're off to the races. Mapping in Power BI can also be challenging, and sometimes it takes a bit of trial and error to get a map close to what you want/need. This post is… Continue reading Create an Interactive Legend in your Power BI Map

Adding a row rank based on a different column with Power Query

Suppose you have two columns of data, one is something to group on and the other is something you could use to rank the rows. It might look something like this (grouping on Person, ranking based on Event Date): Now let's say that you'd like to use Power Query to add a column that ranks… Continue reading Adding a row rank based on a different column with Power Query