Forum Discussion

ConnorH's avatar
ConnorH
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago
Solved

Help with YoY % change

Hi,   I have a table below. I am trying to take the [gross running YTD] column and find the percentage growth to the next value. So for example the value 994143 wont have a percentage growth becau...
  • ConnorH's avatar
    ConnorH
    5 years ago

    Just got this problem figured out so I am sharing the solution in case someone comes accross this thread with a similar problem.

    Var prevValue = CALCULATE(MAX('Table'[Gross Revenue YTD]), FILTER('Table', 'Table'[Gross Revenue YTD] < EARLIER('Table'[Gross Revenue YTD])))
    Var currentValue = 'Table'[Gross Revenue YTD]
    var difference = currentValue-prevValue
    return DIVIDE(difference,prevValue)
ConnorH's avatar
ConnorH
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Just got this problem figured out so I am sharing the solution in case someone comes accross this thread with a similar problem.

Var prevValue = CALCULATE(MAX('Table'[Gross Revenue YTD]), FILTER('Table', 'Table'[Gross Revenue YTD] < EARLIER('Table'[Gross Revenue YTD])))
Var currentValue = 'Table'[Gross Revenue YTD]
var difference = currentValue-prevValue
return DIVIDE(difference,prevValue)