Forum Discussion

NewbieJono's avatar
NewbieJono
Post Partisan
4 years ago
Solved

adding text to a measure

i have a measure that returns a number.   AverageApplicationsPerDay = averagex(values('Task Requested Date'[Date]), 'DFP Applications'[Application Review Count])   could i add text before it to ...
Need Help
  • jppv20's avatar
    jppv20
    4 years ago

    NewbieJono 

     

    This should work:

     

    AverageApplicationsPerDay =

    "Average Applications Per Day - " &

    format(averagex(values('Task Requested Date'[Date]), 'DFP Applications'[Application Review Count]),"0.00")

Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

Hi NewbieJono ,

You can try below code:-

AverageApplicationsPerDay =
VAR result =
    AVERAGEX (
        VALUES ( 'Task Requested Date'[Date] ),
        'DFP Applications'[Application Review Count]
    )
RETURN
    "Average Applications Per Day - " & result

 

Thanks,

Samarth