Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello guys,
I am trying for the last 3 days to figure our how to have the total column in decimal duration (which I did), yet, i don't want to have the decimal duration for each interval, and I am very unlikely to make it happen anytime soon. Can someone help out in this matter? thank you!
Are your durations datetime with "hh:mm:ss" format? And is "Interaction Duration" in your matrix a measure?
If yes, to both, then the below should evaluate wherever [Interaction Duration] evaluates. If not, please provide additional info re: data types, model, current related DAX in use, and provide some simple dummy data that reproduces your problem.
Decimal Duration =
VAR secs =
DATEDIFF(
DATEVALUE( "00:00:00" ),
[Interaction Duration],
SECOND
)
VAR intEquiv =
60 -- 1 min = 1.0
// 60 * 60 -- 1 hr = 1.0
// 24 * 60 * 60 -- 1 day = 1.0
RETURN
INT( secs / intEquiv )
+ MOD( secs, intEquiv ) / intEquiv
Yes, the durations are hhmmss format, the problem is that I only need the total column duration as decimal, not for each interval that I have (from 12:30 to 00:00). I am using the following measures for this visual
I understand now. You have all the components you need. Just replace the BLANK() in the ISINSCOPE condition with your hh:mm:ss measure. Or put it in a third measure (and to visualize what I mean) :
Adjusted_detail-hhmmss_total-decimal =
IF(
ISINSCOPE( df_dazn_AHT[Interval] ),
[Adjusted_Interaction_duration_hhmmss],
[Total_min_decimal_adjusted]
)
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.