Forum Discussion

hassanh_2's avatar
hassanh_2
New Member
3 years ago
Solved

DAX Function to Create a Column Based on condition / filter in another column

Hello, Im trying to create a new column that returns a value from another table based on condition / filter.   As you see I have the following 2 tables. I want to create a new column in Table 2, i...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi hassanh_2 
    Please try

    NewColumn =
MAXX (
    TOPN (
        1,
        CALCULATETABLE ( Table2, USERELATIONSHIP ( Table1[Acct Nr], Table2[Acct Nr] ) ),
        Table2[Log_ID], ASC
    ),
    Table2[Sales Person]
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi hassanh_2 
Please try

NewColumn =
MAXX (
    TOPN (
        1,
        CALCULATETABLE ( Table2, USERELATIONSHIP ( Table1[Acct Nr], Table2[Acct Nr] ) ),
        Table2[Log_ID], ASC
    ),
    Table2[Sales Person]
)
  • hassanh_2's avatar
    hassanh_2
    New Member
    3 years ago

    Hi, Thanks!

    It seems you switched the Table Numbers but I tried both ways and the new column didnt return any value!