Forum Discussion
adding text to a measure
i have a measure that returns a number.
This should work:
AverageApplicationsPerDay =
"Average Applications Per Day - " &format(averagex(values('Task Requested Date'[Date]), 'DFP Applications'[Application Review Count]),"0.00")
5 Replies
- Samarth_18Community Champion
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 - " & resultThanks,
Samarth
- jppv20Solution Sage
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.
- NewbieJonoPost Partisan
how can i format the number to be only two decimal placements
- Samarth_18Community Champion
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 ) - jppv20Solution Sage
This should work:
AverageApplicationsPerDay =
"Average Applications Per Day - " &format(averagex(values('Task Requested Date'[Date]), 'DFP Applications'[Application Review Count]),"0.00")