Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
particleandwave
Frequent Visitor

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?

1 ACCEPTED SOLUTION
Daniel29195
Super User
Super User

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

View solution in original post

1 REPLY 1
Daniel29195
Super User
Super User

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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.