Forum Discussion
Solved
Multiple Dates
Hi I'm really stuck and hoping you can help. My module contains A fact table for TASKS, containing multiple date fields, CREATED DATE, DUE DATE, COMPLETED DATE A date table with an active re...
Hello DonBisset
It is a pretty common problem. Take a look at this post that discusses how to handle it.
https://blog.enterprisedna.co/working-with-multiple-dates-in-power-bi/
As aj1973 stated above you can use the USERELATIONSHIP function to help you here.
Create two inactive relationships for your other date columns and then you would need to specify them within a CALCULATE function.
For example:
CALCULATE ( SUM ( tasks ), USERELATIONSHIP ( tasks[due date], date[date] ) )
This will use the inactive relationship between due date and your date table rather than the relationship with created date.
Hope this helps!