Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
71 |