Forum Discussion

XaviOV's avatar
XaviOV
Helper V
3 years ago
Solved

Create a new column with a multipe value

Hi,   I have a table  and I want to do it, how can I do it in DAX   Now:   Future:   Thanks!
DAX
  • tamerj1's avatar
    tamerj1
    3 years ago

    XaviOV 

    please try

    Column1 =
    MAXX (

    FILTER (

    CALCULATETABLE ( 'Table', ALLEXCEPT ( 'Table', 'Table'[ExecutionReference] ) ),

    'Table'[DataKey] IN { "HP", "GAF" }
    ),

    'Table'[DataKey]

    )

tamerj1's avatar
tamerj1
Community Champion
3 years ago

XaviOV 

I mean why "GAF" not "Caudal" for example? Based on what? Or you have a list of the Key values that need to be kept?

XaviOV's avatar
XaviOV
Helper V
3 years ago

Hi tamerj1  and FreemanZ 

 

The column ExecutionReference that is a unqie value of a register, if in the column DataKey cointains "HP or "GAF" in the new column (Column1) will appear "HP" or "GAF" for the same ExecutionRefence, equal that in the picture. 

 

Regards,

 

Xavi

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    XaviOV 

    please try

    Column1 =
    MAXX (

    FILTER (

    CALCULATETABLE ( 'Table', ALLEXCEPT ( 'Table', 'Table'[ExecutionReference] ) ),

    'Table'[DataKey] IN { "HP", "GAF" }
    ),

    'Table'[DataKey]

    )