Jos13Helper III6 years agoSolvedDATEDIFF Hi Team, I have the following data I just wanted to count those records with status = "IN" and the time difference between the dates > 30 minutes for the same mobile number. In this example, ...Show Moretex628 to Icey6 years agoJos13 , I think this works, see the attached file./ J Intervals.pbix53 KB
Jos13Helper III to Jos136 years agoThe gap between the calls from the same mobile number should be greater than 30 minutes in order to count it once. And the status should also be "IN".
Related contentDATEDIFF DAXDATEDIFF Working DaysDATEDIFFDateDiff Incorrect outputDATEDIFF excluding weekends
