Forum Discussion
Adding leading and trailing characters to measure
Hope this is easy to solve:
I have this expression that works fine:
Hi Fusilier2
Can you please try the below DAX?
I have just corrected the RETURN Part. (It should be formatted in text format.)VAR KPI Incr good% % Total =
VAR Excl_Casuals_MOM =
IF(HR_data[Headcount Excl Casuals month on month] < 0, 1, 0)
VAR Apprentices_MOM =
IF(HR_data[Apprentices month on month] < 0, 1, 0)
VAR mytest = 12
VAR Total_MOM = Excl_Casuals_MOM + Apprentices_MOM
VAR Result = DIVIDE(Total_MOM, mytest)
RETURN
"(" & FORMAT(Result, "0%") & ")"
If this answers your questions, kindly accept it as a solution and give kudos.
2 Replies
- mdaatifraza5556
Super User
Hi Fusilier2
Can you please try the below DAX?
I have just corrected the RETURN Part. (It should be formatted in text format.)VAR KPI Incr good% % Total =
VAR Excl_Casuals_MOM =
IF(HR_data[Headcount Excl Casuals month on month] < 0, 1, 0)
VAR Apprentices_MOM =
IF(HR_data[Apprentices month on month] < 0, 1, 0)
VAR mytest = 12
VAR Total_MOM = Excl_Casuals_MOM + Apprentices_MOM
VAR Result = DIVIDE(Total_MOM, mytest)
RETURN
"(" & FORMAT(Result, "0%") & ")"
If this answers your questions, kindly accept it as a solution and give kudos.- Fusilier2
Helper V
That works. Thank you so much for your help!