Forum Discussion
Best method for modeling with different date dimensions
We have a use case where the user needs to calculate metrics and slice their data based on 3 different date dimensions:
- Policy Year
-Accident Year
-Calendar Year
Should this be achieved via DAX, or should I create 3 different date tables in the data model?
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 👍🫡
1 Reply
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 👍🫡