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

Share This:
Twitter
Facebook
LinkedIn

Stay up to date with the latest customer data news, expert guidance, and resources.

Iteration and Error Handling in M Query

All iteration roads in M Query eventually lead to the List.Generate function. In strengthening our data manipulation skills through Power Query, we absolutely need this looping function.

More Resources

Trusted By Over 6 Million End Users​

Industry leaders and over 6 million end users choose SkyPoint as their comprehensive and compliant Modern Data Stack Platform. A Gold Certified Microsoft Partner, SkyPoint Cloud turns siloed customer data into connected customer experiences.