Forum Discussion
Create a calculated Column
Hai All, Need your Help, I want to create a column yes or no, if the value is blank also want to consider it as "NO" otherwise "yes" Note: Both Columns are from Different Tables.
Hi AlanP514 , for linking 2 tables you can use RELATED() & USERRELATION() etc.
1. Create a new column:
Value1 = CALCULATETABLE(SUMMARIZE(Table1,(Table1[VALUE1]), USERELATIONSHIP(Table2[UniqueKeyToJoinTable1],Table1[UniqueKeyToJoinTable1]))
2. Rsult_Column = If(ISBLANK('table1'[Value1]), "No", IF(ISBLANK('table2'[Value2]),"No", IF('table2'[Value2]="No", "No", "YES")))
AlanP514 -> If this works for you then please mark it as a solution and hit the thumbs up. Thank you.
Regards,
TruptiS