Forum Discussion

Frequent Visitor

3 years ago

Solved

Adding a column in a table with values from another table

Hi, I want to add a column in table 1 with true/false if the values from table 2 is the same as table 1. Table 1: Table 2:

v-xiaosun-msft
3 years ago
Hi AnneMi ,

You just need to change the return values of IF function. For example, true->1, false->0, you can create a column as below.

Column = IF(RELATED('Table 2'[Column1])='Table 1'[number],1,0)

Final output:

Best Regards,
Community Support Team _ xiaosun

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

Frequent Visitor

3 years ago

Thank you very much! It worked. If I want to mark the values for 0 and 1 instead of true/false. What does this formula look like?