Forum Discussion

dmagoo22's avatar
dmagoo22
New Member
8 years ago

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