cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## Get the Date difference between values

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

3 REPLIES 3
Super User

@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

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Helper I

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

Super User

@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.

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors