Forum Discussion

miguel_tc_27's avatar
miguel_tc_27
Regular Visitor
3 years ago

Sales Growth

Hello, I have a problem related to sales growth calculations. I want to calculate the sales growth and I have ['Competition'][Costco ($)] with the revenues and ['Competition'][Year] with only the ye...
devanshi's avatar
devanshi
Icon for Helper V rankHelper V
3 years ago

salesgrowth =

VAR pervoiusyears=CALCULATE(SUM(['Competition'][Costco ($)] ),['Competition'][Year]=(EARLIER(['Competition'][Year])-1))

RETURN

   DIVIDE((['Competition'][Costco ($)] )-perviousyear,perviousyear)

miguel_tc_27's avatar
miguel_tc_27
Regular Visitor
3 years ago

The function EARLIER is not accepting that. It says the parameter is not correct