Forum Discussion
if else statement between 2 Tables
Hi zouweyhd
RELATED is a DAX function. You should use it in a calculated column in data model rather than in a custom column in Power Query Editor.
In Data view, click New column and enter below code in the formula bar.
Nettowert = IF ( RELATED ( 'table2'[VGTYP] ) IN { "H", "K", "N", "O" }, [NETWR] * -1, [NETWR] )* The RELATED function requires that a regular relationship exists between the current table and the table with related information. You need to create a relationship on the common column in advance. And ensure that each row has only one related "VGTYP" value in the other table.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Super Userzouweyhd , You need to move column one table to another or compare them in measure using common dimensions
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
i have built this statement but im not sure if it will do
v-jingzhangCommunity Support
Hi zouweyhd
RELATED is a DAX function. You should use it in a calculated column in data model rather than in a custom column in Power Query Editor.
In Data view, click New column and enter below code in the formula bar.
Nettowert = IF ( RELATED ( 'table2'[VGTYP] ) IN { "H", "K", "N", "O" }, [NETWR] * -1, [NETWR] )* The RELATED function requires that a regular relationship exists between the current table and the table with related information. You need to create a relationship on the common column in advance. And ensure that each row has only one related "VGTYP" value in the other table.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
