Forum Discussion
Calculating Time
Hi, So I have got 2 tables. For instance, table x and table y. Table x is basically a snapshot or the same table as table y, however table x is a snapshot taken at the start of a day at 05.30am ...
Hi maxkhan
Thank you for your reply. Is the primary key between your two tables a many-to-many relationship? Can you create some sample data? I don't need you to provide your original data. As long as you create some examples, I can provide you with solutions. The sample data I create may be different from yours.
Best Regards!
Yolo Zhu
No, it is one to many in both of them. Are you happy to do a webex call to help me sort this out?
Hi maxkhan
If one direction is x table, and the 'many direction' is y table, the dax i offered should work, can you provide the code you entered? and we can't call , it is better that you can provide some sample data.
Best Regards!
Yolo Zhu