Forum Discussion
dmagoo22
8 years agoNew Member
Format the DateDiff Result into a Numerica Value
I have a function that I created in SQL that returns the difference between 2 dates. This function eliminates time for weeknights and weekends so it's not a 24 hour calculation. What I would like to do is see if it's possible to format that result into an HH:MM value that I then can show within a Visualization in PowerBI. I'm not sure if this is possible, or if I could have a custom field that dynamically will update when used in the chart....
Thoughts,
Dennis
No RepliesBe the first to reply