topic Re: Convert text to pourcentage in DAX Commands and Tips

Convert text to pourcentage

hendraoui — Wed, 04 Jan 2023 09:01:37 GMT

Hello everybody,

How to convert a value with type text in pourcent?

Thanks 🙂

Re: Convert text to pourcentage

tamerj1 — Wed, 04 Jan 2023 09:18:57 GMT

Hi hendraoui

It depends on how the text look like?

Re: Convert text to pourcentage

hendraoui — Wed, 04 Jan 2023 09:23:23 GMT

it looks like this:

Re: Convert text to pourcentage

tamerj1 — Wed, 04 Jan 2023 09:27:10 GMT

hendraoui

Ah.. you want to use Power Query? Then just replace the "," with "." then change data type to %

Re: Convert text to pourcentage

hendraoui — Wed, 04 Jan 2023 09:35:46 GMT

I try this but does not 😞

Re: Convert text to pourcentage

tamerj1 — Wed, 04 Jan 2023 09:57:28 GMT

hendraoui

I tried from my end and Power Query automatically converted the text to number without me even doing anything. Make sure to check if you have some cells that contain letters or hidden special characters. You may also try Tranform - Trim and Trasform - Clean if you cannot see any visible character.

Re: Convert text to pourcentage

FreemanZ — Wed, 04 Jan 2023 10:18:00 GMT

hi hendraoui

it looks like you have data from a specific locale, like Germany.

try to

1) right click the column, choose Change Type -> Using Locale, choose Decimal Number and English(Germany), and OK to close.

2) change it to percentage as usual.

Re: Convert text to pourcentage

hendraoui — Wed, 04 Jan 2023 13:03:42 GMT

We just had to replace the empty cells with null 😉