Forum Discussion

mHarbo's avatar
mHarbo
New Member
5 years ago

I have problem regarding the datediff

I have problem regarding the time difference between two dates.    The dax code is: DATEDIFF([AssignedDate],CALCULATE(Min([Modified]), [RevisionNumber]>[RevisionNumber]+1),HOUR)   The reason for...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

mHarbo , Try a new column like

DATEDIFF([AssignedDate],MinX(filter(Table,[RevisionNumber]>earlier([RevisionNumber])+1),[Modified]),HOUR)