Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
84 | |
69 | |
68 | |
39 | |
38 |