Detecting Overlapping Contracts with List.Dates() in Power BI

The business rule is simple; a client’s new contract should always begin the day after the previous contract ends. Everybody gets it, but the world is also a busy place where well intentioned people still make mistakes. People extend contracts without pushing out the following contract and people set contracts to start and end on the same day. Creating visibility around this often involves cumbersome Excel reports by hand, eating up valuable analyst time. In this video I’m going to show you how to build an automated report which can surface these problems as quick as they show up. In the process you’ll learn about structured values and see the different ways grouping can wrestle down tricky data problems.

Click here to download the PBIX companion file

Brian Grant

Brian Grant

Brian Grant is a masterful Senior Analytics Consultant by day, and a Power BI legend by night. A passion for Power BI drove him to holistically master the tool from all three perspectives: M, DAX, and the visualization layer. Brian is a constant teacher who leads Power BI training sessions, while sharing his wealth of expertise through video and blogging resources.
Share on twitter
Share on facebook
Share on linkedin
Share on email


Subscribe to CSG. We’ll supply your inbox with the latest blog posts, training videos, and upcoming events.

Ready to wrangle your data?