topic Re: DAX Function to Create a Column Based on condition / filter in another column in DAX Commands and Tips

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

hassanh_2 — Tue, 29 Nov 2022 08:51:59 GMT

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, in that column I need to return the "Sales Person" of the first Log_ID.

(Note: in my relationship model there is an Inactive relationship by "Acct Nr.")

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

tamerj1 — Tue, 29 Nov 2022 08:58:41 GMT

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] )

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

hassanh_2 — Tue, 29 Nov 2022 09:36:41 GMT

Hi, Thanks!

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

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

hassanh_2 — Tue, 29 Nov 2022 09:47:52 GMT

I created the same function as a measure and it worked. Thank you!

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

hassanh_2 — Tue, 29 Nov 2022 10:04:35 GMT

Is there a way though to create it as a Column so I can use it as a Parameter dimension in other visuals?

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

tamerj1 — Tue, 29 Nov 2022 10:38:14 GMT

hassanh_2

What is the direction of the relationship between the two tables? Can you provide a screenshot?