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...
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
5 years ago

mHarbo 

=VAR _rn=[RevisionNumber] RETURN DATEDIFF([AssignedDate],MINX(FILTER(Table,[RevisionNumber]>_rn+1),[Modified]),HOUR)