Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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.
Solved! Go to 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.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.