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 sale...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity 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?

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      6 years ago

      That is all just a single measure.

      • thems5's avatar
        thems5
        Regular Visitor
        6 years ago

        Thank you Greg. I will try it.