Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. 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]
)