Forum Discussion
Card Visual
Here's another way I'd like to present this problem. I have one table that I want to display the # of hours and minutes worked. When selecting each of the subcategories, I do see the sum of hours worked (top box), however, if I want to display the time as "hours" and "minutes", I don't get the same results (bottom box).
Lots of different ways to approach this.
This video shows one that you should be able to adapt to your needs.
https://www.youtube.com/watch?v=Z1hGU93UE1c&ab_channel=NestorAdrianzen
EDIT: another good option, https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-using-dax
- Anonymous5 years agoNot applicable
I followed the YouTube example, and feel this is a good solution. However, I have one error that I can't seem to resolve. Everything looks accurate. Any suggestions?
- KNP5 years ago
Super User
In your return statement, I think you need to put a 'FORMAT' around the DaysInt. It will be trying to concatenate number with text.