Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I have a dataset with this columns and I need to aggregate the values in the outage duration. I need to get total outage duration for a certain date(last down) and the total overall outage duration.
By this dataset, I need to aggregate this so I can have a card visual to display total outage duration (1 Days 4 Hrs 28 Mins 19 Secs)
Solved! Go to Solution.
you can do the data transform in PQ
1. replace hrs to 3600, replace mins to 60 and replace secs to 1
2. split the column by space
3. create a new column to get seconds
at last you can create a dax
Measure =
VAR total=SUM('Table'[Custom])
VAR _day=INT(total/3600/24)
VAR _h=int((total-_day*3600*24)/3600)
VAR _min=INT((total-_day*3600*24-_h*3600)/60)
VAR _sec=int((total-_day*3600*24-_h*3600-_min*60))
return _day&" Days "&_h&" Hrs "&_min&" Mins "&_sec&" Secs"
the output is different from yours. could you pls double check your expected output?
pls see the attachment below
Proud to be a Super User!
How about if there are in days in the column as well like "2 days 5 Mins 5 Secs"? What is the value to replace the days text?
you can do the data transform in PQ
1. replace hrs to 3600, replace mins to 60 and replace secs to 1
2. split the column by space
3. create a new column to get seconds
at last you can create a dax
Measure =
VAR total=SUM('Table'[Custom])
VAR _day=INT(total/3600/24)
VAR _h=int((total-_day*3600*24)/3600)
VAR _min=INT((total-_day*3600*24-_h*3600)/60)
VAR _sec=int((total-_day*3600*24-_h*3600-_min*60))
return _day&" Days "&_h&" Hrs "&_min&" Mins "&_sec&" Secs"
the output is different from yours. could you pls double check your expected output?
pls see the attachment below
Proud to be a Super User!
How about if there are in days in the column as well like "2 days 5 Mins 5 Secs"? What is the value to replace the days text?
then change days to 86400
Proud to be a Super User!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
93 | |
87 | |
84 | |
70 | |
49 |
User | Count |
---|---|
141 | |
120 | |
112 | |
59 | |
59 |