Need Help On Calculating Cummulative Values

[ayanmazumderpbi]

Hello Friends,

I need to calculate the following -

CREATE_DATE	Total	Records Processed	Record Pending	Measure needed
3/2/2023 0:00	233	135	98	233
3/3/2023 0:00	35	20	15	170
3/4/2023 0:00	41	38	3	196
3/6/2023 0:00	22	16	6	215

Please refer the following excelsheet for the formula and details. If i can get your guidance on this it will be a great help.

https://docs.google.com/spreadsheets/d/1WzHxERAEZSrivbI1aD3aHLCmXVuxacsC/edit?usp=sharing&ouid=10654... 

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

Expected result measure: =
VAR _prevprocessed =
    CALCULATE (
        SUM ( Data[Records Processed] ),
        WINDOW (
            1,
            ABS,
            -1,
            REL,
            ALL ( Data[Date], Data[Records Processed], Data[Record Pending] ),
            ORDERBY ( Data[Date], ASC )
        )
    )
RETURN
    IF ( HASONEVALUE ( Data[Date] ), [Total:] + _prevprocessed )

[ayanmazumderpbi]

Instead of calculated column. When i will be using measures, Will this formula work.