Forum Discussion

XaviOV's avatar
XaviOV
Icon for Helper V rankHelper 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]

    )

XaviOV's avatar
XaviOV
Icon for Helper V rankHelper V
3 years ago

Hi tamerj1 ,

 

Based on ExecutionReference

 

Regards,

 

Xavi

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity 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
    Icon for Helper V rankHelper 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
      Icon for Community Champion rankCommunity Champion
      3 years ago

      XaviOV 

      please try

      Column1 =
      MAXX (

      FILTER (

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

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

      'Table'[DataKey]

      )