Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi-
Problem
I have two tables, table 1 is the main 'master table' and table 2 is an update table.
Essetially data is recorded in table 2 as a change log and tracks updates made in the first table.
Table 1
Table 2
Solution
What I would like to be able to do is create a new column on table 1 that gives a true value if the Risk ID in table one is in Table 2.
This has to be an additional column to the table.
so something like
R01 | TRUE |
R02 | FALSE |
R03 | FALSE |
R04 | FALSE |
R05 | FALSE |
Solved! Go to Solution.
@Anonymous , A new column in Table 1
New column =
var _cnt = countx(filter(Table2, Table2[ID] = Table1[ID]), Table1[ID])
return
if(isblank(_cnt), "Yes", "No")
@Anonymous , A new column in Table 1
New column =
var _cnt = countx(filter(Table2, Table2[ID] = Table1[ID]), Table1[ID])
return
if(isblank(_cnt), "Yes", "No")
Thanks that works really well.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |