How to extract text with an if condition in one step in Power Query

How to extract text with an if condition in one step in Power Query

Curbal

3 года назад

31,634 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

@RajenderKumar-ei2cp
@RajenderKumar-ei2cp - 16.09.2023 22:04

That error came up and you laughed , it was hilarious 😂

Ответить
@JenMayB
@JenMayB - 09.07.2023 18:21

Thank you so much! I am currently looking to extract the value. It is seven digits long. Hopefully you have a video on that.😊

Ответить
@deniseortiz8567
@deniseortiz8567 - 28.06.2023 18:58

🤣Educational AND HILARIOUS!! Gracias!!

Ответить
@MarcoMagal
@MarcoMagal - 13.06.2023 12:30

Fantastic❤

Ответить
@NigelMayhew1
@NigelMayhew1 - 05.06.2023 09:10

Thank you very much Ruth!

Ответить
@Rida9651
@Rida9651 - 26.04.2023 21:38

I love that you kept the bug and fixing part in the video ahahhaa

Ответить
@inamullahkhan5761
@inamullahkhan5761 - 31.01.2023 22:06

tell me more than 2 measure slicer

Ответить
@bluex5115
@bluex5115 - 24.01.2023 13:59

hy, thanks for this. please help me with an issue like this : column with many lines - i want to find position and extract text, combination of certain letters "mo" & 1 number from 0-9, for example 1 line - didnt work something like tihis
= Table.AddColumn(#"Changed Type", "EXTRACT", each Text.PositionOf([NAME],"mo" & {"0".."9"}))
monk12 monique24 mo5266 mother21
cannot use mo , cannot find no, but i want to find position of mo5 and extract mo5266 - and so on to entire column
thanks

Ответить
@axelamoe
@axelamoe - 13.10.2022 11:20

this help me find out my answer, thank you

Ответить
@TechGuyChad
@TechGuyChad - 24.09.2022 05:15

This one is just what I need. One issue I have though is I have multiple each if statements to transform the one column.

For example this is my statement is below. Curbal can you do multiple each if like I have below?

= Table.TransformColumns(#"Duplicated Column", {{"TRAVELNBR", each if Text.Contains(_, "V") or each if Text.Contains(_, "Q") then Text.Middle(_, 0, 8) else _, type text}})

Ответить
@olehbalaban8504
@olehbalaban8504 - 08.09.2022 18:22

How would you do this if text contains <

Ответить
@rleigh5204
@rleigh5204 - 31.08.2022 20:26

This was a FABULOUS video and has saved me a lot of heartache. Thank you very much!!

Ответить
@badminton4life99
@badminton4life99 - 17.06.2022 01:32

How may I remove a hyphen on left or right of a letter in a string, but do nother with a hyphen between numbers. Example below:
00-CM-00-12
00C-M-00-12
00CM-00-12
After transform steps, or in one step returns
00CM00-12

Thanks 🙏

Ответить
@sucmitra
@sucmitra - 29.03.2022 18:33

May you plz tell me if there is any example for inserting text if row doesn't contain that text.
Some rows have abc-1458
But some rows are without abc-
I am not able to text.insert bcz then abc- gets doubled abc-abc-1458
Can anyone plz help

Ответить
@leemarkin
@leemarkin - 01.11.2021 17:35

i don't understand, if can't put just put a column name in it, then how can i do it if it depends on other columns?

Ответить
@adamwheeler1702
@adamwheeler1702 - 09.10.2021 03:24

A perfect video as always.

Ответить
@davidcadman3562
@davidcadman3562 - 14.04.2021 14:00

Hi Ruth. Another fantastic tip. I wonder if when doing these in-column transformations can an IF statement refer to another column as well e.g. if _ = 101 and [Column1] = "x" then 999 else _ I get "We cannot apply field access to the type number" when trying. Maybe you already covered this.

Ответить
@Freemachains
@Freemachains - 31.03.2021 08:14

Thank you for all the effort you do to bring us always useful infos <3

Ответить
@tariqraza5405
@tariqraza5405 - 04.03.2021 08:09

Excellent, one of the best Power Bi , Power Query and DAX channel i found, thanks Ruth for clearing very complex concepts of dax and power BI in such a nice way..

1) Ruth, is there any possibility to start M Fridays (M language Power Query) same way as DAX Fridays.
2) Can you make detailed video on "lambda " function of excel.

if it is possible

Again thanks very much for providing such a excellent channel.

Ответить
@2404Pepe
@2404Pepe - 02.03.2021 21:18

Excelente video Ruth!!! consulta sobre otro tema. Acabo de cargar la nueva versión de una Tabla desde Azure y obtengo el error "la secuencia no contiene ningún elemento coincidente" al actualizar de Power Query al Power BI, alguna idea sobre este error?? no he encontrado nada en internet, todo lo que hay está relacionado con otros temas. Agradezco tu respuesta !!!!! abrazo

Ответить
@riazuddin7493
@riazuddin7493 - 02.03.2021 11:19

I created a dashboard in power bi but it is showing as report how can i convert it to dashboard also please help me in creating alerts

Ответить
@jorstube
@jorstube - 02.03.2021 02:02

Jajajaja eso fue divertido y Util

Ответить
@abhijeetghosh27
@abhijeetghosh27 - 02.03.2021 01:43

Another cool trick .. loved it 😃❤

Ответить
@700997372mp
@700997372mp - 01.03.2021 19:23

great video, love the deliberate mistake - its always good to see the mistakes so w can understand why it went wrong

Ответить
@ShabnamKhan-vk7fj
@ShabnamKhan-vk7fj - 01.03.2021 17:54

Thank you for the quick tip video, it will come in handy. Great thumps up for you, Ruth <3

Ответить
@cedjulemckeever
@cedjulemckeever - 01.03.2021 17:17

A question from a newbie, why are there 2 curly brackets after "Source," and at the end after "type text" ?

Ответить
@lokesh2635
@lokesh2635 - 01.03.2021 16:41

Very helpful ruth

Ответить
@xodrinker
@xodrinker - 01.03.2021 16:32

Cool. And an enjoyable vid it was 😊

Ответить
@tariqraza5405
@tariqraza5405 - 01.03.2021 16:12

Hi Ruth, what is the concept of 'min' in this statement.

Ответить