Report SPliting

[thobenjo]

Hi Experts if you can see these are 3 different accounts combined to one gl account, how can I split this into different sheets so that I can take a better report

[v-luwang-msft · Accepted solution]

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