adding text to a measure

[NewbieJono]

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 display e.g "Average Applications Per Day - 2.742

[NewbieJono]

how can i format the number to be only two decimal placements 

[jppv20 · Accepted solution]

@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]

You can do it by using below code:-

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

[jppv20]

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.

[Samarth_18]

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