Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 45 | |
| 35 | |
| 30 | |
| 15 | |
| 15 |
| User | Count |
|---|---|
| 58 | |
| 55 | |
| 38 | |
| 21 | |
| 21 |