Forum Discussion
Solved
If and statements between different tables
Hi im trying to based on 2 conditions from different tables give a decided value or else 0. Have tried to put in a custom column: if([Besparelse] = 1 and (#"Kontoplan"[Mva Norge] =>0 then 0,2...
Da_clint , In the power query you have to merge tables before you can write some condition across table, AFter merge, they are in a single table.
In DAX you can bring the column back into your table
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
amitchandak
Super User
Super UserDa_clint , In the power query you have to merge tables before you can write some condition across table, AFter merge, they are in a single table.
In DAX you can bring the column back into your table
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