Forum Discussion
Datediff between two tables no relationship
Hi Experts is it possile to work out the difference in datas between two dates in two different tables no direct releationship.
Anonymous
it depends on your data model. if you could provide exactly matching via LOOKUPVALUE() function or if somenthing LIKE FIRSTNONBLANK() or any aggregation functions like MIN() or MAX() will ensure enough quality for your business logic you will be able to do DATDIFF() easily
Greg_Deckler
Community Champion
Community ChampionAgree with az38 , depends. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490