Forum Discussion

usmanrafiq's avatar
usmanrafiq
Helper I
6 years ago
Solved

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:avg...
Need Help
  • rajatanand's avatar
    rajatanand
    6 years ago

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

AllisonKennedy's avatar
AllisonKennedy
Community Champion
6 years ago
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