Remember the recent blogs about the folks at the Elizabeth Glaser Pediatric AIDS Foundation (EGPAF) who are using Power BI to help prevent and eliminate Pediatric AIDS? And the folks at the Center for Oceans at Conservation International (CI) who are using Power BI to improve ocean health? Well one reader was so inspired by those amazing people and their stories, that he set out to find a way he could use Power BI to make a difference.

This article explains how to create a Date Dimension Table in Power BI’s Query Editor with an additional set of columns that will allow you to sort report display columns in your Date Dimension, add conditional formatting capabilities, and last but not least, perform relative filtering on current ( 0 ), previous ( -1, -2… ) or future ( 1, 2... ) Date, Week or Month and many more.

If you were an MBAS Speaker, make sure to claim your badge!