Solved: Problem with DATEDIFF

GoodMan85 · ‎08-26-2022

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 · ‎08-26-2022

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

✔ Answered? Mark as solution

Muhammad Hasnain | Super User • Fabric • Power BI • Data Engineering

Let's connect on LinkedIn

mh2587 · ‎08-26-2022

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

✔ Answered? Mark as solution

Muhammad Hasnain | Super User • Fabric • Power BI • Data Engineering

Let's connect on LinkedIn

Problem with DATEDIFF