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]

)

Community Champion

3 years ago

based on what?

Helper V

3 years ago

Based on ExecutionReference

Regards,

Xavi

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
  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]
    
    )
FreemanZ
Super User
3 years ago
ExecutionReference doesn't make sense, what if you sort that column.

Related content