Forum Discussion
AdministratorUnified Date Filter
If a single table contains multiple date columns with potentially different values in the same row, it’s best to use a dedicated dates dimension table. You can then create multiple relationships from each date column to the dates table—one active (since only one active relationship is allowed at a time) and the rest as inactive. Use USERELATIONSHIP in a measure to invoke it. Similarly, if you have multiple tables and want them to be filtered by a common date field, you should use the same approach with the shared date dimension.
Those with broken lines in the image below are inactaive relationships
Please see the attached pbix for details.
Super UserIf a single table contains multiple date columns with potentially different values in the same row, it’s best to use a dedicated dates dimension table. You can then create multiple relationships from each date column to the dates table—one active (since only one active relationship is allowed at a time) and the rest as inactive. Use USERELATIONSHIP in a measure to invoke it. Similarly, if you have multiple tables and want them to be filtered by a common date field, you should use the same approach with the shared date dimension.
Those with broken lines in the image below are inactaive relationships
Please see the attached pbix for details.
AdministratorGood afternoon, I hope you are well
Thank you very much for your answer and sorry for the delay
I've rarely used the USERELATIONSHIP feature, but it's the right thing to do with what I need, so we'll need to investigate it further.
Thanks a lot