Forum Discussion
relationship active & inactive
- 1 year ago
Hi New_worker - Please find the answers in Bold
Solution1: For each date foreign key, you add inactive relationships between the sales table and the date table YES
Solution2: From Power Query Editor, you rename the date query as Due Date. You reference the Due Date query twice to make the queries for Order Date and Delivery Date. YES
Solution3: From the Fields pane, you rename the date table as Due Date. You use a DAX expression to create Order Date and Delivery Date as calculated tables.NO
Solution4: You create measures that use the USERELATIONSHIP DAX function to lter sales on the active relationship between the sales table and the date table. NO
Solution5: You create measures that use the USERELATIONSHIP DAX function to lter sales on the inactive relationship between the sales table and the date table. YES
I hope it helps
Hi New_worker ,
Hi! I’m glad to see that your issue seems to be resolved. If the provided solution helped, could you kindly mark it as the accepted solution? This helps other users with similar questions find the answer more easily. Thank you!