Forum Discussion

JImAyers's avatar
JImAyers
Icon for Helper I rankHelper I
3 years ago
Solved

Rolling Total with a twist

I have a rolling total that sets an upper limit of 5; the total can't exceed 5. All is good as long as actual total doesn't exceed 5 in which case the negative values in the values column are subtrac...
  • CNENFRNL's avatar
    CNENFRNL
    3 years ago

    The DAX calculation involves recursion, which is too hard to be (almost) impossible for most DAX users, me included. In comparison, Power Query solution is way more feasible as shown above.