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

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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      Thennarasu_R
      Responsive Resident
      2 years ago

      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

  • 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