Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I've a column called DurationConnected in seconds and I've converted via the query editor to hh:mm:ss in a new column called DurationConnected(min) like this: #time(0, 0, 0) + #duration(0, 0, 0, [DurationConnected]). This gives me what I want but the format is text (I know it's a common issue).
I only need this data in hh:mm:ss in a multi row card chart. Can I do this via a measure in the chart? Or does anyone have a tip here?
Thanks.
Solved! Go to Solution.
hi, @Anonymous
After my test, you can do these as below:
Assume that we have this basic table
Step1:
use the formula like you to add a custom DurationConnected(min) column
#time(0, 0, 0) + #duration(0, 0, 0, [DurationConnected in seconds])
Step2:
Close&Apply
Step3:
select column DurationConnected(min) then click->Modeling->Data type->Time
Step4:
then select column DurationConnected(min) and click->Modeling->Format->Date Time->(HH:mm:ss)
Result:
Best Regards,
Lin
hi, @Anonymous
After my test, you can do these as below:
Assume that we have this basic table
Step1:
use the formula like you to add a custom DurationConnected(min) column
#time(0, 0, 0) + #duration(0, 0, 0, [DurationConnected in seconds])
Step2:
Close&Apply
Step3:
select column DurationConnected(min) then click->Modeling->Data type->Time
Step4:
then select column DurationConnected(min) and click->Modeling->Format->Date Time->(HH:mm:ss)
Result:
Best Regards,
Lin
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |