Forum Discussion
Anonymous
4 years agoNot applicable
Card Visual
I want to use the Card visual to show the total hours worked for support calls for when a category is selected e.g., Software, Hardware, etc.. Each request has an ID assigned, however, there may be...
KNP
4 years agoSuper User
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
Anonymous
4 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?
- KNP4 years agoSuper 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.