Forum Discussion

M4r3's avatar
M4r3
Frequent Visitor
4 years ago

Calculate cummulative value until condition

Hello community!   I am trying to calculate some cummmulative values in DAX, but would like to stop the calculation after a certain condition. My measure looks like this:       Sum X Quarters ...
General Comment
Need Help
M4r3's avatar
M4r3
Frequent Visitor
4 years ago

For the summing up quarters I used the EDATE and it works as it should:

IF(EDATE(xDates,((xQuarters - 1) * 3) ) < DATE(2022,6,30) , Result, 0))

Now I need only the solution for my MAX 🙂

MAX('Claim Development Quarters'[Claim Development])

 

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Community Support
    4 years ago

    Hi M4r3 ,

     

    Sorry, don't quite understand what you need, please provide some example data and please enter the results you want manually in excel.

     

     

    Best Regards

    Community Support Team _ chenwu zhu

     

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

     

    • M4r3's avatar
      M4r3
      Frequent Visitor
      4 years ago

      Sure, thank you for the effort. I am attaching the .pbix and Excel files. https://we.tl/t-aGjicVIRSK

       

      Basically the only thing I would still like to do is to get the DATE(2022,6,30) fixed value in the measure 'Sum X Quarters' replaced with the MAX date from the [Claim dvelopment] table.

       

      Thank you!