Forum Discussion

nyarlathotep's avatar
nyarlathotep
Advocate I
10 months ago
Solved

DAXUDF Reference a column

So, i want to make a DAX UDF that takes a (one-column) table as input and outputs a concatenation of all distinct values.

 

Something like:

DEFINE FUNCTION

ConcValues = (column: Table) => CONCATENATEX( DISTINCT(column), ???columnName???, ", ")

 

Since i can pass any table, the column name is variable and cannot be hard-coded in the UDF.

 

Any ideas how to implement this? How to make a reference to a column name? Or how to reference the column of a table by a number, i.e. the 2nd column of the table or the first column, etc)

DAXUDF
UDF
  • Jihwan_Kim's avatar
    Jihwan_Kim
    10 months ago

    Hi,

    I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file, and please try something like below.

     

     

     

     

3 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    10 months ago

    Hi,

    I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file, and please try something like below.

     

     

     

     

  • nyarlathotep's avatar
    nyarlathotep
    Advocate I
    10 months ago

    Jihwan_Kim that works! I could have sworn that i had tried anyref but i must have messed somewhere else - my actual measure is a bit more complex that the simplified version i posted here. Anyway, problem solved, thanks mate!