Forum Discussion

JEM_Systems's avatar
JEM_Systems
Helper I
2 years ago

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

 

 

 

Need Help

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    2 years ago

    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/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

    • JEM_Systems's avatar
      JEM_Systems
      Helper I
      2 years ago

      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's avatar
        Greg_Deckler
        Community Champion
        2 years ago

        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.