Merged Tables vs Related Tables

Hi HotChilli 

Thanks for your reply.

1st Part - I was trying to know if there's a way to create a calculated column with fields from different tables.

For instance, I have a calculated column to obtain the milestone status in my first table. And in the second table I have a calculated column to get the number of days that a ticket have on pending customer status.

And I would need to calculate the number of days left until the milestone target, summarizing with the number of days in pending customer, for the tickets in pending customer status (in this situation the milestone is stopped, and so the number of days that is stopped will be added and the target date is postponed).

It would be something like this:

Days to SLA =

IF('Merged_Table'[Milestone_Status] = "Not provided", DATEDIFF('Merged_Table'[Today],'Merged_Table'[Target_Date],DAY),

IF('Merged_Table'[Milestone_Status] = "Stopped", DATEDIFF('Merged_Table'[Today],'Merged_Table'[Target_Date],DAY) + [Ongoing Pending Customer Time]))

However I cannot perform this DAX, because [Milestone_Status] has been created in the first table, and the [Ongoing Pending Customer Time] on the second table. Even if I have relationship between them of Many-to-One. The second table has duplicates, btw.

2nd Part - I was not able to test what you have suggested, but I was discussing and testing a lot of options and was able to find a solution (at least until a new issue comes ahahahah).

Don't know exactly the order of the process, because I tested so many things that I can't remember everything I did. But basically I created a column to define values as 1 or 0, and then I created the column to get the number of days for pending customer time. I still had to solve the duplicates, but defined them as null and could exclude them from the table. For now it is working. Hope I don't get more issues of this kind!

Thank you for your help 😉