shainisHelper I7 years agoSolvedDATEDIFF help Hi, I'm trying to calculate DATEDIFF but getting weird results... I would like to see in "Column" 1.5, 1.5, 2, 1.5 etc. I'll appreciate your help with that. Thanks! Show MoreAlB7 years agoHi shainis A few questions:Can you share the pbix? Are [EndDate] and [EventDate] measures? Can you show their code?Is what you want to calculate a column or a measure? In the meantime, try this instead: ([EndDate] - [EventDate]) * 24 which should yield the difference in hours
AlB7 years agoHi shainis A few questions:Can you share the pbix? Are [EndDate] and [EventDate] measures? Can you show their code?Is what you want to calculate a column or a measure? In the meantime, try this instead: ([EndDate] - [EventDate]) * 24 which should yield the difference in hours
AlB7 years agoHi shainis A few questions:Can you share the pbix? Are [EndDate] and [EventDate] measures? Can you show their code?Is what you want to calculate a column or a measure? In the meantime, try this instead: ([EndDate] - [EventDate]) * 24 which should yield the difference in hours
AlBCommunity Champion7 years agoHi shainis A few questions:Can you share the pbix? Are [EndDate] and [EventDate] measures? Can you show their code?Is what you want to calculate a column or a measure? In the meantime, try this instead: ([EndDate] - [EventDate]) * 24 which should yield the difference in hours
shainisHelper I to AlB7 years agoThanks, AlB, that worked! An alternative solution would be to use the Time Subtruct. Both are doing the job.Thank you!
Related contentDATEDIFF DAXDATEDIFF Working DaysDateDiff Incorrect outputDATEDIFFDATEDIFF excluding weekends
Helper I
