Complicated concatenate

Hi Analitika ,

You didn't provide the main information. Based on what is it to be grouped? How do we know that the first PRD record is to contain the concatenation of the first two PGs, and the second PRD of the third PG?

I need to know the logic of this.

EDIT: I already noticed - the last second column contains this.

_______________
If I helped, please accept the solution and give kudos! 😀

Analitika , see like you have to create new column

example

switch ( True(),

[DOCKMNR] in {"B001","B002"} && [Sub_apr_nr] = "XY" , "PRD",

// more condition

blank()

)

refer

https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-power-query/

Hi Analitika ,

Using the second last column, you can write two measures that will sum the values and concatenate the document numbers:

Sum of _payments =
SUMX (
    FILTER (
        ALL ( opzurant ),
        opzurant[Sukab_2.ApNr] = SELECTEDVALUE ( opzurant[DOKUMNR] )
    ),
    [_payments]
)

Concat of Dokumnr =
CONCATENATEX (
    FILTER (
        ALL ( opzurant ),
        opzurant[Sukab_2.ApNr] = SELECTEDVALUE ( opzurant[DOKUMNR] )
    ),
    opzurant[DOKUMNR],
    ", "
)

The result:

_______________
If I helped, please accept the solution and give kudos! 😀