how to remove cumulative total

[Anonymous]

Hi Everyone,

I am trying to convert finnacial statement from excel to power Bi. But some of the values are getting added up for every month. How should I get back to the original values of the month!! if you see the picture below, you can see that for net sales i can see for all allowances, freight and gross sales, everything is getting added up? how should i remove this? very confused. tried almost everything but not helpingas you can see, everything in the net sales is getting added up with months, how do i see indivual values for months. i mean the original values

[v-gizhi-msft · Accepted solution]

Hi,

Please try to create this column first:

MonthNo = MONTH('Table'[Date])

Then you can try this measure to show the original data:

Measure = 
CALCULATE (
    MAX ( 'Table'[Values] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        'Table'[Department] IN FILTERS ( 'Table'[Department] )
            && 'Table'[Category] IN FILTERS ( 'Table'[Category] )
            && 'Table'[MonthNo] = MAX ( 'Table'[MonthNo] )
    )
)
    - CALCULATE (
        MAX ( 'Table'[Values] ),
        FILTER (
            ALLSELECTED ( 'Table' ),
            'Table'[Department] IN FILTERS ( 'Table'[Department] )
                && 'Table'[Category] IN FILTERS ( 'Table'[Category] )
                && 'Table'[MonthNo]
                    = MAX ( 'Table'[MonthNo] ) - 1
        )
    )

The result shows like this:

Here is my test pbix file:

pbix 

Hope this helps.

Best Regards,

Giotto

[Greg_Deckler]

Hard to tell with the information provided. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490