Forum Discussion

GoodMan85's avatar
GoodMan85
Frequent Visitor
4 years ago
Solved

Problem with DATEDIFF

Hi Guys,

I jhave a problem with DATEDIFF formula.

I need to make the formula on date fields of different tables.

Please help me.

 

Ex. DATEDIFF between HH Doc Date and B.P. Req Date.

 

Thanks

Need Help
  • mh2587's avatar
    mh2587
    4 years ago

    DateDifference =
    VAR StartDate = MAX(Table[HH Doc Date])
    VAR EndDate = MAX(Table[B.P. Req Date])
         RETURN 
                     DATEDIFF ( StartDate, EndDate, DAY ) 

1 Reply

  • mh2587's avatar
    mh2587
    Super User
    4 years ago

    DateDifference =
    VAR StartDate = MAX(Table[HH Doc Date])
    VAR EndDate = MAX(Table[B.P. Req Date])
         RETURN 
                     DATEDIFF ( StartDate, EndDate, DAY )