Forum Discussion

Ion_Gomez's avatar
Ion_Gomez
Frequent Visitor
6 years ago
Solved

Group display values

Hello everyone I would like to know if it is possible to add the values of the columa that says "Order Code" on a single line. Attached image This is how the matrix display comes out when I ...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi  Ion_Gomez ,

     

    Create an index column in power query and a calculated column as below:

     

    _Order number = 
var _index=MAXX(FILTER('Table','Table'[Index]<EARLIER('Table'[Index])&&'Table'[Order number]<>BLANK()),'Table'[Index])
Return
IF('Table'[Order number]=BLANK(),CALCULATE(MAX('Table'[Order number]),FILTER('Table','Table'[Index]=_index)),'Table'[Order number])

     

    Then create a measure as below:

     

    Measure = CONCATENATEX(FILTER(ALL('Table'),'Table'[_Order number]=MAX('Table'[_Order number])),'Table'[Order code],"-")

     

    And you will see:

    For the related .pbix file,pls click here.

     

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Ion_Gomez ,

 

you can try this this measure

 

Concat =
CONCATENATEX (
    FILTER (
        ALL (
            'Table'[Codigo Proyecto],
            'Table'[Codigo Pedio]
        ),
        'Table'[Codigo Proyecto]
            = MAX ( 'Table'[Codigo Proyecto] )
    ),
    CALCULATE (
        MAX ( 'Table'[Codigo Pedio] )
    ),
    UNICHAR ( 10 )
)

 

 


Regards,

Harsh Nathani


Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!