Problem with DATEDIFF

[GoodMan85]

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

[mh2587 · Accepted solution]

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