Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello
i am trying to replace from a column double quotes "
first i try to use something like : substitute(mycolumn,"""," ")not worked, also i try to use "/"", try using a variable , tempvar=unichar(22), but nothing seems to work,
Do you have any ideea? Thx
Solved! Go to Solution.
Hi @cristianj
you can either do it with power query
like below
Go to power query> select your column> select transform tab> select replace value>
Put " in value to find and add single space replace with
see above value is replaced with space.
you can try with dax also
create calculated column and write below dax
I hope I answered your question!
Hi @cristianj
you can either do it with power query
like below
Go to power query> select your column> select transform tab> select replace value>
Put " in value to find and add single space replace with
see above value is replaced with space.
you can try with dax also
create calculated column and write below dax
I hope I answered your question!
it's not working 😞
can you share the snip of the column vaue that has ''
can you try below dax:
ReplacedColumn = SUBSTITUTE('mycolumn', "\"", "")
and can you show snip of the double quotes in data
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
97 | |
75 | |
63 | |
62 |
User | Count |
---|---|
142 | |
104 | |
104 | |
80 | |
66 |