Get the Date difference between values

[JEM_Systems]

Hi, how can I get de date difference between documents numbers from the same Name? I'm trying to identify the time the Company Name did the last Sales Order.

Could someone help me?

It Can be on a measure or a calculated column.

Thanks

[Greg_Deckler]

@JEM_Systems Not sure I quite understand. Can you provide an example of correct output? Seems like everything would be 0 days in your example. This might help:

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

[JEM_Systems]

The output should be the number os days of difference. The date on my example is all 10/03/2023 because all of these orders are from today.

I do not understand your example, what VAR __Current = [Value] is? @Greg_Deckler 

[Greg_Deckler]

@JEM_Systems That just grabs the row's current value of the Value column and stores it in a variable. Subtracting two dates gives back the number of days since a date is just an integer of the number of days since 12/30/1899. If necessary, you can force it to be a number with a RETURN of this:

(__Current - __Previous) * 1.