Best method for modeling with different date dimensions

[particleandwave]

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?

[Daniel29195 · Accepted solution]

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 👍🫡