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