Forum Discussion
Concatenate Measure and String
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 & " mins" ,SUM(driviology2[ga:avgSessionDuration]) & " secs")
4 Replies
Avg. Session Duration = if(AVERAGE(driviology2[ga:avgSessionDuration])/60 >= 1 , AVERAGE(driviology2[ga:avgSessionDuration])/60 & " mins" ,SUM(driviology2[ga:avgSessionDuration]) & " secs")
- 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 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 🙂
