topic Re: Create a new column with a multipe value in DAX Commands and Tips

Create a new column with a multipe value

XaviOV — Fri, 10 Feb 2023 11:35:20 GMT

Hi,

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

Now:

Future:

Thanks!

Re: Create a new column with a multipe value

tamerj1 — Fri, 10 Feb 2023 12:48:14 GMT

Hi XaviOV

based on what?

Re: Create a new column with a multipe value

XaviOV — Fri, 10 Feb 2023 13:08:57 GMT

Hi tamerj1 ,

Based on ExecutionReference

Regards,

Xavi

Re: Create a new column with a multipe value

tamerj1 — Fri, 10 Feb 2023 13:47:22 GMT

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?

Re: Create a new column with a multipe value

FreemanZ — Fri, 10 Feb 2023 13:53:51 GMT

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

Re: Create a new column with a multipe value

XaviOV — Fri, 10 Feb 2023 14:03:20 GMT

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

Re: Create a new column with a multipe value

tamerj1 — Fri, 10 Feb 2023 14:23:57 GMT

XaviOV

please try

Column1 =
MAXX (

FILTER (

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

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

'Table'[DataKey]

)