Forum Discussion
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 ...
This should work:
AverageApplicationsPerDay =
"Average Applications Per Day - " &format(averagex(values('Task Requested Date'[Date]), 'DFP Applications'[Application Review Count]),"0.00")
how can i format the number to be only two decimal placements
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 )This should work:
AverageApplicationsPerDay =
"Average Applications Per Day - " &format(averagex(values('Task Requested Date'[Date]), 'DFP Applications'[Application Review Count]),"0.00")
