DATEDIFF across two different tables help please (please so much)

[Pricey79]

Can someobdy please help me. I've been watching youtube and reading on here for what seems like hours and just cannot get this to work.

I have two dates, one in one query and another in another query. All I want to do is know the difference between the two in working days. 

I've tried Related and it doesnt show the other table as an option, and I've checked and there is an active relationship.

Is there something else to try different to Related?

Can anyone please hlep?

Thank you in advance. 

[Pragati11 · Accepted solution]

HI @Pricey79 ,

Can you share some screenshot here on what kind of relationship you have between these 2 tables and on what columns?

Also which date columns you are using to create a difference?

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Thanks,

Pragati

[Pricey79]

@Pragati11 

Thank you. 

It;s now been solved. Thank you for your reply