Forum Discussion

ayanmazumderpbi's avatar
ayanmazumderpbi
Frequent Visitor
3 years ago
Solved

Need Help On Calculating Cummulative Values

Hello Friends,

I need to calculate the following -

 

CREATE_DATETotalRecords ProcessedRecord PendingMeasure needed
3/2/2023 0:0023313598233
3/3/2023 0:00352015170
3/4/2023 0:0041383196
3/6/2023 0:0022166215

 

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=106544875250600527735&rtpof=true&sd=true 

@Dax help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    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 )

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    3 years ago

    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's avatar
      ayanmazumderpbi
      Frequent Visitor
      3 years ago

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