Forum Discussion
IvanSinelnyk
4 years agoNew Member
custom data labels
Hi everyone. Need help. I have column with number of seconds (number type) and I need that big numbers (~32 000 000) transform to days, hours ... I allredy made it with DAX. But can't use this resul...
- 4 years ago
Hi IvanSinelnyk ,
Text value could not be used in the Value field if want to show like x days x hours x minutes x seconds. You can create a meaure like this to use it as a tooltip:
Average = VAR _avg = AVERAGE ( 'Table'[Time value(s)] ) VAR _day = ROUNDDOWN ( _avg / 3600 / 24, 0 ) VAR _hour = ROUNDDOWN ( ( _avg - _day * 3600 * 24 ) / 3600, 0 ) VAR _minute = ROUNDDOWN ( ( _avg - _hour * 3600 ) / 60, 0 ) VAR _second = ROUND ( _avg - _hour * 3600 - _minute * 60, 2 ) RETURN _day & " Days " & _hour & " Hours " & _minute & " Minutes " & _second & " Seconds"Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
4 years agoNot applicable
= Table.AddColumn(NameOfPriorStep, "Duration", each #duration(0,0,0,[NameOfSecondsColumn]))
--Nate