Im using a measure to calculate the minutes difference between 2 times.
But the datediff measure, the calculations between the 2 dates are incorrect. not sure if there's a format setting that I'm missing here.
Example below, difference between 13:00:00 and 13:15:00 should be 15 minutes, but im getting 120.
1 ACCEPTED SOLUTION
@ben-t , if this is measure then it would have data for same group.
If this is a new column. Not no need for sumx. Just use datadiff
or
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
@ben-t , if this is measure then it would have data for same group.
If this is a new column. Not no need for sumx. Just use datadiff
or
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Thanks, found there were duplicate lines that were grouped together with the same name.
removed duplicates and calculations correct now.
