DAX CONTAINS( ) function

Happy 2015 Power Pivot Freaks! Should be an exciting year as Microsoft seems intent on pushing forward with its self-service BI strategies and the Power BI stack. I suspect we will see a new version of Office this year, so I will be excited to see which of my dreams come true. Today I wanted to talk a bit about the CONTAINS() function. The msdn reference gives one example, but it's a bit rough to come up with scenarios where it's really applicable. I saw a great example from Chris Webb (@technitrain) for an "events in progress" problem. and that comes up pretty frequently; I suspect using CONTAINS() against dates is going to be a useful technique.