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")

jppv20's avatar
jppv20
Solution Sage
4 years ago

Hi NewbieJono ,

 

You can use this measure:

AverageApplicationsPerDay =

"Average Applications Per Day - " &

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

 

If I answered your question, please mark it as a solution to help other members find it more quickly.