Forum Discussion

Learner86's avatar
Learner86
Icon for Helper I rankHelper I
4 years ago
Solved

Creating new columns based on colums from related Table

Dear community,    I want to create new columns based on other columns from another table using IF-condition. I hope you can help me. Image I have the following two tables   Table1:    ID   1 ...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Learner86 

    Time new =
MAXX (
    FILTER ( RELATEDTABLE ( Table2 ), Table2[Status] = "New" ),
    Table2[Time]
)
    Time In Progress =
MAXX (
    FILTER ( RELATEDTABLE ( Table2 ), Table2[Status] = "In Progress" ),
    Table2[Time]
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Learner86 
Can you please provide the expected output? Do you want that using M or DAX?

Learner86's avatar
Learner86
Icon for Helper I rankHelper I
4 years ago

tamerj1: You can find my expected output in my first post. I want to use DAX.