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

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]
)
Learner86's avatar
Learner86
Icon for Helper I rankHelper I
4 years ago

Many thanks for the proposed solution. There is just one point: How can I combine the two tables by using of the ID-columns?

  • 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.