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.
Dears,
i was looking to replace( '- ) with ( - ) since in my Excel sheet i have some values with '-70000. the dash caused a problem.
when trying to replace it in power query it doesn't allow me to do it. do you have any other idea how to do in power Query
i have also in some columns date in this format 20170410, how can i change the colmn so the date will looks like 10/04/2017?
br,
Can you create a sample and past it as a table into the body of the post, with both examples?
Hello,
this is the example you have requested. so in case the cell is written with '- it will be just - and delete (') to be converted into number which is below 0. and for date , i want to be displayed as 06/07/2020.
Value | Date |
'-770000 | 20200705 |
Thanks in advance.
below what i go when i added what you have shared with me.
below what i have under power query and i've highlighted what you shared with me, just changing the name of the colmn. thanks to help me with this error.
Thanks
You almost got it!
But you should change #"PreviousStep" to #"Changed Type1", you must have missed the part where I said that 🙂
It should be
#"Transf.... (#"Changed Type1", ...
in
#"Transform Stuff"
Cheers
Hi,
even with the update, nothing happend (see below)
please can someone help.
thanks
please tell me exacetly how can i implement what you have proposed ? i'm beginner in using PBI.
Thanks a lot
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.