Cummulative getting error while applying the date between filter

[Thennarasu_R]

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 and Regards,
Thenn

[Thennarasu_R · Accepted solution]

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

[Anonymous]

Hi @Thennarasu_R 

Based on your needs, I have created the following table.

Use the following formula to create a date table, depending on your specific needs.

Date = CALENDAR(DATE(2024,2,14),DATE(2024,2,24))

Establish a relationship between the date columns of two tables in Model View.Then you can use the following dax to get the result you want.

Cumulative Total Up To Selected Date = 
VAR SelectedMaxDate = MAX('Date'[Date])
VAR SelectedMinDate = MIN('Date'[Date])
RETURN
SUMX(
    FILTER(
        ALL('Date'),  
        'Date'[Date] <= SelectedMaxDate && 'Date'[Date] >= SelectedMinDate
    ),
    CALCULATE(SUM('Table'[Value]))
)

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Thennarasu_R]

@Anonymous 

I found the selected date cummulative , my requirement is not selected date cummulative .

For ex now you selcted 2/15/2024 to 2/17/2024 if selected dates between it should cummulative only start date to 2/15/2024 datas only  should change based on date selection. If you want more clarification let me know.

Thanks and Regards,
Thennarasu R