Create a new column with a multipe value

[XaviOV]

Hi,

I have a table  and I want to do it, how can I do it in DAX

Now:

Future:

Thanks!

[tamerj1]

Hi @XaviOV 

based on what?

[XaviOV]

Hi @tamerj1 ,

Based on ExecutionReference

Regards,

Xavi

[FreemanZ]

ExecutionReference doesn't make sense, what if you sort that column. 

[tamerj1]

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

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 · Accepted solution]

@XaviOV 

please try

Column1 =
MAXX (

FILTER (

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

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

'Table'[DataKey]

)