Concatenate Measure and String

[usmanrafiq]

Hello, 

I want to create a measure that calculates avg session duration and attach "min" or "sec" word with it based on following condition

Avg. Session Duration = if(AVERAGE(driviology2[ga:avgSessionDuration])/60 >= 1 , AVERAGE(driviology2[ga:avgSessionDuration])/60 ,SUM(driviology2[ga:avgSessionDuration]))

If i create another measure for sec or min and concatenate with above calculation , its gave me error. 

I want to use it in cards visual. 

Expected output would be 

1.5 mins or  

35 secs  

[amitchandak]

@usmanrafiq , Refer

https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-i...

https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-usi...

[AllisonKennedy]

@usmanrafiq you don't need to create another measure for mins or secs, just add this to the existing measure:

Avg. Session Duration = if(AVERAGE(driviology2[ga:avgSessionDuration])/60 >= 1 , AVERAGE(driviology2[ga:avgSessionDuration])/60 ,SUM(driviology2[ga:avgSessionDuration])) & " mins"

You can also do some limited custom formatting in the measures using the Model Properties view; https://radacad.com/custom-format-fields-and-measures-in-power-bi

[rajatanand · Accepted solution]

Avg. Session Duration = if(AVERAGE(driviology2[ga:avgSessionDuration])/60 >= 1 , AVERAGE(driviology2[ga:avgSessionDuration])/60 & " mins" ,SUM(driviology2[ga:avgSessionDuration]) & " secs")

[Fowmy]

@usmanrafiq 

I am not sure what your column driviology2[ga:avgSessionDuration] returns, is t seconds or Minutes ?

Wrap with FORMAT ([Measure],"General") & "Min"

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn