Forum Discussion
Tables with multiple date fields
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/
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/
It was the limitation you mention that was causing an issue and i have overlooked. I reserched more the date table generation and now understand that date tables are generated for each date field auotmatically with an option to create my own using the AutoCalendar function.
Thanks,
SJM