Cross verification between two tables and if condition is true, return 0

[bishnu]

Hello

i am trying to create a table A (first table) in powerbi such that it checks data from table B, if true it returns 1 and if false 0

for example it will check for Doc-COD1 -'A_02', if the status in table B is 'Verfied', it should return 1 in the corresponding Doc1, similarly if Doc-COD2 -'A_03', if the status in table B is 'Verfied', it should return 1 in the corresponding Doc2 or else 0

Thanks in advance

Table ATable B

[dax · Accepted solution]

Hi @bishnu , 

It seems that you want to replace value for each column, right? If so, you could try to refer to bulk-replace-values  for details. You also could refer to my sample for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.