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.
My data looks like the image below. I want, for example to convert "P.AZUCAR________220" into "P.AZUCAR 220 kV". Ideally to "P. Azucar 220 kV" (space after dot) but the first one will definetly be great.
Solved! Go to Solution.
Hi @dvhez,
on the query editor select the column right click then replace values replace the _ by nothing and redo the replace and do the 220 by " 220 kV"
this should give the expected result.
No need to split columns.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @dvhez,
Although your data is always 220 on the end of the column here is a formula to add the last 3 digits and kV to beginnin.
Column = LEFT(Table[Column];FIND("_";Table[Column];1)-1) & " " & RIGHT(Table[Column];3)& " kV"
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @dvhez,
on the query editor select the column right click then replace values replace the _ by nothing and redo the replace and do the 220 by " 220 kV"
this should give the expected result.
No need to split columns.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsI'm trying to do this in DAX though :(. My data has almost 60 million rows and it takes 1 hour aprox to apply changes to that specific query.
Hi @dvhez,
Although your data is always 220 on the end of the column here is a formula to add the last 3 digits and kV to beginnin.
Column = LEFT(Table[Column];FIND("_";Table[Column];1)-1) & " " & RIGHT(Table[Column];3)& " kV"
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |