Forum Discussion
Solved
Tables with multiple date fields
Hi, I have a single 'Incidents' table that has multiple date fields e.g. "CreatedOn" and "ClosedOn". I've already hooked these fields up as foreign keys to a sinlge Date table which happily d...
I am not exactly sure what it is you are trying to accomplish, but you will need to consider into your solution the limitation of one active relationship between two tables. Check out this post:
https://kzhendev.wordpress.com/2014/02/12/role-playing-dimensions-dax-vs-mdx-part-1/
Hello, i hope it's not too late. i think i know what you are looking for and where to find it.
You need to relate multiple dates from your fact table to a calendar table. All you need to do is use the USERELATIONSHIP DAX function.
Here is how:
https://www.youtube.com/watch?v=sONvctPlplY
and also you could use
https://msdn.microsoft.com/en-us/query-bi/dax/userelationship-function-dax
Hope it helps.