Forum Discussion

powerbidu's avatar
powerbidu
Frequent Visitor
1 year ago
Solved

Create 'IF' function across 2 tables

Hi all, I have the below dataset: Table 1       Identifier Deadline     A 5     B 6     C 7     D 8     E 9                     Table 2    ...
"DAX " "DAX help" 'Need help' 'DAX'
  • vivek31's avatar
    vivek31
    1 year ago

    HI powerbidu,

     

    you can use lookupvalue function and create a column 

    Day taken more = 
var identifier = LOOKUPVALUE(Table__1[Deadline],Table__1[Identifier],Table__2[Identifier]) 
RETURN
IF(Table__2[Days taken] > identifier ,"YES","NO")

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

vivek31's avatar
vivek31
Resolver II
1 year ago

HI powerbidu,

 

you can use lookupvalue function and create a column 

Day taken more = 
var identifier = LOOKUPVALUE(Table__1[Deadline],Table__1[Identifier],Table__2[Identifier]) 
RETURN
IF(Table__2[Days taken] > identifier ,"YES","NO")

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