In calculated column , how to replace Lookupvalue with Related and create SQL script

[Nazdac911]

Hi All

I have 2 tables : Table 1 and Table 2 , (1 --> M relation)

In Table 1: I am creating the  following calculated column:

TableA[Col Z] =

LOOKUPVALUE(

        TableB[Col X] , Table[B] [Col Y], "String_Value",

        TableA[Col PK] , TableB[Col SK] , 

        "N/A")

This line work great .

I need help for 2 things:

• I want to use Related instead of lookup
• How could I create the equivalent SQL script for this DAX script?

Thanks in advance  

[amitchandak]

@Nazdac911 , A new column in Table A

Coalesce(maxx(filter(Table2, Table[2] = "Value"), Table2[X]) , 0)

or

Coalesce(sumx(filter(Table2, Table[2] = "Value"), Table2[X]) , 0)

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

[Nazdac911]

Hi 

Thank you for the fast reply .. 

I will need to digest the coalsec function , i never work with it before .. 

but unfortunality it did not work and gave me the follwoing error message 

I updated my lookupvalue function and added the Value is a string value ( all relative columns are string columns) 

Thank you for sharng the youtube videios , they are of great value 

Regarda