Forum Discussion

MahamoodBi's avatar
MahamoodBi
Frequent Visitor
3 years ago

findout date difference between two dates and non dates

Hi PBI experts,   I have one simple requirment need to findout date differnece between ''Service date'' and ''Term.Date'' 2.But for Emp.No - 19031 i dont have data in "Service Date" Column a...
Help me
tips & tricks
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

MahamoodBi First part is easy, it is 

Measure =
  ( MAX([TermDate]) - MAX([ServiceDate]) ) * 1.

2nd part:

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

  • MahamoodBi's avatar
    MahamoodBi
    Frequent Visitor
    3 years ago

    Greg_Deckler i need both dax function in single caluclated column ,could you please suggest

     

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      3 years ago

      MahamoodBi Right, that's a simple

      IF( MAX('Table'[ServiceDate]) <> BLANK(),

        ( MAX([TermDate]) - MAX([ServiceDate]) ) * 1.,

        ... //second measure goes here

       )

      • MahamoodBi's avatar
        MahamoodBi
        Frequent Visitor
        3 years ago

        Greg_Deckler i need to divided by 12,because i am finding date difference between two dates by month

         

        second point coding i didný understood could you please cexplain