Forum Discussion

sj_'s avatar
sj_
Frequent Visitor
7 years ago
Solved

Help with DAX formula

Hi!    Given two tables A (green) and B (blue), I need to fill out column B (complete/incomplete) based on Status column in table B. (See "Table A ID" - many to one relationship from table B to A) ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    Try this:

     

    Column = 
VAR __table = SELECTCOLUMNS(RELATEDTABLE('TableB'),"__status",[Status])
RETURN
IF("Open" IN __table,"Incomplete","Complete")
Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

Try this:

 

Column = 
VAR __table = SELECTCOLUMNS(RELATEDTABLE('TableB'),"__status",[Status])
RETURN
IF("Open" IN __table,"Incomplete","Complete")
sj_'s avatar
sj_
Frequent Visitor
7 years ago

Thank you so much!