DATEDIFF with values in different Rows and Fields

DaniBi92 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/339586.
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

DaniBi92 

You can create a DX table with the following code.  Click New Table under the Modeling tab and paste the code given below, rename the table name as per yours.

Result Table = 
ADDCOLUMNS(
    ADDCOLUMNS(
        VALUES(Table1[ITEM]),
        "DATE1", CALCULATE(MIN(Table1[DATE1])),
        "DATE2", CALCULATE(MIN(Table1[DATE2]))
    ),
    "RESULT", DATEDIFF([DATE1],[DATE2],DAY)
)

Hi, DaniBi92 

Please check the below picture and the sample pbix file's link down below.

All measures are in the sample b pbix file, and all steps are numbered in front of each measure.

https://www.dropbox.com/s/4lwg972lhq9ki9q/danibi.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM