Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Values form multiple rows to one row

Hello, I would like to have values from multiple rows into one row.   For this ID i have multiple dates in multiple rows which i would like to have in one row.   I would like to do this in...
DAX
multiple rows
one row
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi Anonymous 

     

    You can create a Table using DAX like below.

    Table 2 = 
ADDCOLUMNS(
    VALUES( 'Table'[ID] ),
    "Date1", CALCULATE( MAX( 'Table'[Date1] ) ),
    "Date2", CALCULATE( MAX( 'Table'[Date2] ) ),
    "Date3", CALCULATE( MAX( 'Table'[Date3] ) )
)

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski

     

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi Anonymous 

 

You can create a Table using DAX like below.

Table 2 = 
ADDCOLUMNS(
    VALUES( 'Table'[ID] ),
    "Date1", CALCULATE( MAX( 'Table'[Date1] ) ),
    "Date2", CALCULATE( MAX( 'Table'[Date2] ) ),
    "Date3", CALCULATE( MAX( 'Table'[Date3] ) )
)

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks Mariusz 

This is the solution!