topic Re: Text to Percentage in DAX Commands and Tips

Text to Percentage

slam — Mon, 22 May 2023 03:13:18 GMT

Dear All,

Please help me to solve this problem. There are including percentages( 0.96 ) and numbers (3100) in a column. So, i want to convert percenatage 0.96 to 96%. Therefore, I add custum column with below formula.

if [Value] = null then null else if [Value]=">95%" then ">95%" else if [Value] <= 1 then Number.ToText([Value] * 100) & "%" else Number.ToText([Value])

The result is

From to

It is worked in some percentage but I have a problem in some results like 7.00000000007%, 55.00000000007 and 19.9.000000000%, 3.500000004%

Best Regards,

Re: Text to Percentage

AjithPrasath — Mon, 22 May 2023 08:20:19 GMT

Please try the below code:

NewColumn =
IF (
ISBLANK ( [Value] ),
BLANK (),
IF (
[Value] = ">95%",
">95%",
IF (
[Value] <= 1,
FORMAT ( [Value] * 100, "0.00%" ),
FORMAT ( [Value], "0.00%" )
)
)
)

Best Regards,

Ajith Prasath

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Text to Percentage

slam — Mon, 22 May 2023 15:25:38 GMT

Thank you very much for your help!