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!