cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RHarley Frequent Visitor
Frequent Visitor

Re: Running Total: Non-date. Blank issues, % movement

@v-juanli-msft

Hi Maggie,

 

Edit: Can I bug you to do a growth percentage calc as well? For example, Dev Qtr 1 divided by Dev Qtr 0. Then Dev Qtr 2 divided by Dev Qtr 1. Set up as the same matrix, but showing the period on period percentage rather than the running totals. That'll cover absolutely everything I need. Not being cheeky, this was part of my original query Smiley Happy

 

I'll have time to look in a few hours, but it looks very promising! Will mark as solution once I have a quick look.

 

Thanks so much!!

Highlighted
RHarley Frequent Visitor
Frequent Visitor

Re: Running Total: Non-date. Blank issues, % movement

@v-juanli-msft

 

Hi Maggie,

 

I've managed to figure out a way on my own for the growth percentage part.

 

I copied your running total formula, and modified with a -1:

 

 
 
RunTot2Prior =
CALCULATE(
    [TotalAmount],
    FILTER(
        ALLSELECTED('new Table'[DevQtr]),
        ISONORAFTER('new Table'[DevQtr], MAX('new Table'[DevQtr])-1, DESC)
    )
)
 
 
 
Then used a DIVIDE:
 
Dev% = DIVIDE([RunTot2],[RunTot2Prior])
 
Thanks for all of your input!