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_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 17...
@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 )
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.