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 ($)] ),SAMEPERIODLASTYEAR(['Competition'][Year]))

RETURN

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

miguel_tc_27's avatar
miguel_tc_27
Regular Visitor
3 years ago
But the thing is Year is not of date type, it is an integer such as 2014. Thus SAMPERIODLASTYEAR does not work correctly.
  • devanshi's avatar
    devanshi
    Icon for Helper V rankHelper V
    3 years ago

    try this formula:

    salesgrowth =

    VAR pervoiusyears=CALCULATE(SUM(['Competition'][Costco ($)] ),DATESYTD(['Competition'][Year]))

    RETURN

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

    • miguel_tc_27's avatar
      miguel_tc_27
      Regular Visitor
      3 years ago

      Has the same problem as before.

      • 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)