Calculated column from more than one table

[zahirmohideen]

Here is my use case

I have dates in few tables and Date Dimension .
In SQL , I do something as below.

Select a.name , b.desc , COALESCE(a.date1 , a.date2 , b.date3 ) , d.FYQtr
from a.id = b.id and COALESCE(a.date1 , a.date2 , b.date3 ) = d.dateus

How do I accompolish this in Power BI ?

Thanks in Advance.

[zahirmohideen · Accepted solution]

Thanks very much , Amit

[amitchandak]

@zahirmohideen , first you have bring table from table B to table a

New column in table A

date3 = Maxx(filter(b, a[id] = b[id] ), b[date3] )

now you can have coalesce column

Date 4= coalesce([date1], [Date2], [Date3])

And now you can use this

refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8