week change amount dax help

[ROG]

Hi guys,

Can you please help me with a dax that gives me the amount difference by week?

I have only one table on my model with the date, country, and amount by product type.

This table shows the number of customers acquired by week for a specific product type.

How can I have another column with difference of each week?

Thanks in advance!

[Greg_Deckler · Accepted solution]

@ROG See my article on Mean Time Between Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395....
The basic pattern is:
Column = 
  VAR __Current = [Value]
  VAR __PreviousDate = MAXX(FILTER('Table','Table'[Date] < EARLIER('Table'[Date])),[Date])

  VAR __Previous = MAXX(FILTER('Table',[Date]=__PreviousDate),[Value])
RETURN
  __Current - __Previous