Forum Discussion

thems5's avatar
thems5
Regular Visitor
6 years ago

Measure formula

Hi experts

I have a table with 2 columns - Year, and Sales per year.I wish to create a measure that will calculate the percentage of change in sales between the years:(Sales of each year, minus sales of the previous year) divided by the Sales of the previous year.

Help anyone?

Need Help

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    Perhaps:

     

    Measure = 

      VAR __Year = MAX('Table'[Year])

      VAR __PreviousYear = __Year - 1

      VAR __Sales = MAXX(FILTER('Table','Table'[Year] = __Year),'Table'[Sales])

      VAR __PreviousSales = MAXX(FILTER('Table','Table'[Year] = __PreviousYear),'Table'[Sales])

    RETURN

      DIVIDE((__Sales - __PreviousSales),__PreviousSales,0)

    • thems5's avatar
      thems5
      Regular Visitor
      6 years ago

      Thanks for your prompt reply Greg.
      I forgot to mention that I am new to DAX, so can you please explain - is this one measure, or each line is a different measure?