Forum Discussion
Best method for modeling with different date dimensions
hello particleandwave
if you want to show the 3 different dates on the same visual,
then you need to create date tables per each .
if you just need a date column and caluclate the data base on these different dates,
it is best to create one date table related to these 3 date columns ( 1 active, 2 inactive ) and the active to be the most date that would be used .
in the measure then , whenever you to
use:
calculate ( .. ... , userelationship ( paramter1 , parameter2 )
)
If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. I would appreciate hitting that kudos 👍🫡
hello particleandwave
if you want to show the 3 different dates on the same visual,
then you need to create date tables per each .
if you just need a date column and caluclate the data base on these different dates,
it is best to create one date table related to these 3 date columns ( 1 active, 2 inactive ) and the active to be the most date that would be used .
in the measure then , whenever you to
use:
calculate ( .. ... , userelationship ( paramter1 , parameter2 )
)
If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. I would appreciate hitting that kudos 👍🫡