Report SPliting

Hi thobenjo ，

As I do not have your specific data, I have created similar data for your reference.

 

First ,create index by power query:

Then create the below index:

rank =
IF (
    'Table'[Column1] = "Expenditure",
    RANKX (
        FILTER (
            'Table',
            'Table'[Column1] = EARLIER ( 'Table'[Column1] )
                && 'Table'[Column1] = "Expenditure"
        ),
        'Table'[Index],
        ,
        ASC
    ),
    0
)

test1 = CALCULATE(MAX('Table'[rank]),FILTER(ALL('Table'),'Table'[Index]<=EARLIER('Table'[Index])))

 

According new column ,create table:

Table2 = CALCULATETABLE('Table','Table'[test1]=1)

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

Best Regards

Lucien