I have two columns in my main table which shows dates from which a contract or a service was in place for, so it has a valid from date and a valid to date.
I want to be able to select one date and this would filter down to any contracts that were active during that time, so if I selected the 11/09/2019 I would get the below result
Dummy data in Power BI look like this
I have included a data table in my report but I’ve not created a relationship yet as I thought perhaps this might require a disconnected date table.
As always, any help/assistance very much appreciated.
You are spot on that this will require a disconnected date table. I actually did a video on nearly this exact scenario a couple of weeks ago. Give this a watch – I think it will give you what you need to solve this one. If you still have questions just give a shout…
I had previously watched this video but the olde brain hadn’t embedded the concepts, perhaps I need a memory upgrade.
Thinking on it a bit more, it’s quite a simple solution at its core but no less very powerful. Love the added bonus of using the measure for conditional formatting!
That happens to me all the time. I’ll watch a video and think “hmmm, cool”, but it doesn’t fully click for me until I have an application of my own to use it on.
)
