Forum Discussion

Thennarasu_R's avatar
Thennarasu_R
Responsive Resident
2 years ago
Solved

Cummulative getting error while applying the date between filter

Hi Team, I'm facing issues in Cummulative calculation there i'm applied the dates between slicer . How it should calculate is only summarize the before from date values should summarize. Thanks...
Need Help
  • Thennarasu_R's avatar
    Thennarasu_R
    2 years ago

    Hi Guys 

    I found it 

    your also facing this issues use tis calculation,Ignored selected date values its summarize before selected date only.

    Cumulative Total Up To Selected Date =
    VAR SelectedMaxDate = MAX('Date'[Date])
    VAR SelectedMinDate = MIN('Date'[Date])
    RETURN
    SUMX(
        FILTER(
            ALL('Date'),  
            'Date'[Date] >=DATE(2023,01,01) && 'Date'[Date] < SelectedMinDate   ----Should be Dim date start date   (2023,01,01)--------
        ),
        CALCULATE(SUM('Table'[Value]))
    )

    Thanks ,
    Thennarasu R
Thennarasu_R's avatar
Thennarasu_R
Responsive Resident
2 years ago

Hi Guys 

I found it 

your also facing this issues use tis calculation,Ignored selected date values its summarize before selected date only.

Cumulative Total Up To Selected Date =
VAR SelectedMaxDate = MAX('Date'[Date])
VAR SelectedMinDate = MIN('Date'[Date])
RETURN
SUMX(
    FILTER(
        ALL('Date'),  
        'Date'[Date] >=DATE(2023,01,01) && 'Date'[Date] < SelectedMinDate   ----Should be Dim date start date   (2023,01,01)--------
    ),
    CALCULATE(SUM('Table'[Value]))
)

Thanks ,
Thennarasu R