Forum Discussion
DAX UseRelationship
Can someone please help me understand if I'm using the proper dax function to achieve the following? I have a factSales table and a Date Dim table. The fact table has OrderDate and ShipDate. I ha...
Hi nchamilton162 ,
Of course you can, but there is already an active relationship between OrderDate from fact table and Date from Date Dim table, so there is no need to create another one-to-many relationship for the Date from Date Dim table.
In addition to USERELATIONSHIP, you can also use RELATED to get Day of Week. Create custom column in fact table with below DAX.
Column = RELATED('Dim Date'[Day of Week])
——————————————————————————————————————————————————
If my answer helps you solve the problem, please accept my answer as a solution and let it be seen by more people in need.
Best regards,
Mengmeng Li