Forum Discussion

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!

tamerj1
3 years ago
XaviOV

please try

Column1 =
MAXX (

FILTER (

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

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

'Table'[DataKey]

)

Helper V

3 years ago

Based on ExecutionReference

Regards,

Xavi

Community Champion

3 years ago

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
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
  Community Champion
  3 years ago
  XaviOV
  
  please try
  
  Column1 =
  MAXX (
  
  FILTER (
  
  CALCULATETABLE ( 'Table', ALLEXCEPT ( 'Table', 'Table'[ExecutionReference] ) ),
  
  'Table'[DataKey] IN { "HP", "GAF" }
  ),
  
  'Table'[DataKey]
  
  )

Related content