Solved: Re: applying a condition on a column without creat...

Anonymous · ‎10-11-2019

hello i'm debutant on power bi
I have a problem with applying a condition on a column without creating a new condition column.

something like that apply this function on the city(ville) column directly :

(please write months the steps) i am debutant

parry2k · ‎10-11-2019

@Anonymous after you added new custom column, why not remove the 1st column and then rename the 2nd column in following steps.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

parry2k · ‎10-11-2019

@Anonymous after you added new custom column, why not remove the 1st column and then rename the 2nd column in following steps.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous · ‎10-11-2019

first of thank you for your answers

I have more than 150 city if I want to apply this function must enter each time the name of the city? Do you have a solution for me?

parry2k · ‎10-11-2019

@Anonymous not sure what you mean 150 cities, if it is rows then no problem or it is 150 columns?

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous · ‎10-11-2019

I have a columns like this with 150 ligne :

evry-centre

paris-nord

marseille-cedex-3

.

I want to transfer them

evry

paris

marseille

.

@parry2k

Anonymous · ‎10-11-2019

@parry2k

i don't want to keep the second column because I have correct city on the first column I just want to correct the city which is not well written on the same column