Running total that restarts after a number of days based off a measure

[mloc1990]

Hi,

Im pretty new to power BI and DAX, I have the running total calculated using the formula below for accounts:

Running Total = CALCULATE(SUM(uwtest[volume]),FILTER(ALL(uwtest),'uwtest'[authdate]<=MAX(uwtest[authdate])),VALUES(Accounts[accountname]))

I have a measure of days that varies depending on the account and I'm trying to calculate it where it will restart the running total for accounts when a certain number of days have been reached.

E.g an account has 133 days and every 133 days the running total will restart.

Thanks for the help!

[v-lili6-msft]

hi, @mloc1990 

The best way is that add a group column for date column (uwtest[authdate] )

Then add a conditional in the measure

Running Total = CALCULATE(SUM(uwtest[volume]),FILTER(ALL(uwtest),'uwtest'[authdate]<=MAX(uwtest[authdate]) && 'uwtest'[group] = MAX('uwtest'[group])),VALUES(Accounts[accountname]))

Best Regards,

Lin

[mloc1990]

Hi @v-lili6-msft 

It's definitely along the lines of what I am needing but when I add the group column I can only select a predefined period that will be the same for all accounts. In the attached images is it possible to do the same setup using a measure I have created called "Medium Days" as each account has a different amount of days for running total.

Thanks!