10 ай бұрын
10 ай бұрын
11 ай бұрын
11 ай бұрын
11 ай бұрын
Жыл бұрын
Пікірлер
@fornax205 4 күн бұрын
Thanks!
@alejandrahorvath 2 күн бұрын
Thank you for your generous contribution Jim! I'm glad you found it useful. Cheers! 😊
@osoriomatucurane9511 22 күн бұрын
Absolutely Awesome, compreenhesive, concise and crystal clear.
@alejandrahorvath 20 күн бұрын
Thanks! Glad you liked it! 😊
@mohammadalbizri2013 Ай бұрын
Cool
@alejandrahorvath Ай бұрын
Glad you liked it! Thanks for watching 😊
@mohammadalbizri2013 Ай бұрын
Highly appreciated
@alejandrahorvath Ай бұрын
Thanks for watching 😊
@gtssocialmedia2118 Ай бұрын
This works perfectly. Thanks a lot. Previously i was transposing the table, then remove empty rows, then transosing again, but this works really well.
@alejandrahorvath Ай бұрын
Glad to hear this is more efficient for you! Thanks for watching 😊
@mohammadalbizri2013 Ай бұрын
Thank you
@alejandrahorvath Ай бұрын
You're very welcome! Thanks for watching! 😊
@gughanraju5681 Ай бұрын
Great content...you could have made it a 20 mins video but live walkalong help me to understand it way better... appreciate your support...
@alejandrahorvath Ай бұрын
Thank you for watching! I'm glad you found it helpful. 😊
@kebincui 2 ай бұрын
Excelent as always. Thank Alej
@alejandrahorvath Ай бұрын
Glad you liked it Kebin! Thanks for watching 😊
@purohith2200 2 ай бұрын
She is so honest and giving great references from where she learnt the techniques and over that she is teaching. She is great!
@alejandrahorvath 20 күн бұрын
Thank you for your kind message. Cheers 😊
@bree3733 2 ай бұрын
This is great content! Thank you so much!
@alejandrahorvath 2 ай бұрын
Glad you liked it! Thanks for watching 😊
@kebincui 2 ай бұрын
Great video about List.Accumulate. Thanks Alej 👍
@alejandrahorvath 2 ай бұрын
Thanks Kebin, glad you liked it! 😊
@nsanch0181 2 ай бұрын
Thank you Alejandra for the neat filter function.
@alejandrahorvath 2 ай бұрын
Glad you like it! Thanks for watching 😊
@Luciano_mp 2 ай бұрын
Nice trick, useful! Thank you.
@alejandrahorvath 2 ай бұрын
Glad it was helpful! Thanks for watching 😊
@ismaelkourouma5558 2 ай бұрын
Thanks Alejandra. In fact, since FILTER function return the boolean logic TRUE, there is no need to mutiply by 1. This just works =FILTER(Table1[#All],ISODD(SEQUENCE(,COUNTA(Table1[#Headers]))))
@alejandrahorvath 2 ай бұрын
Thank you very much Ismael! Cheers! 😊
@pallet48 2 ай бұрын
a very clever lady
@alejandrahorvath 2 ай бұрын
Thanks for watching 😊
@jayendrakhadikar1291 2 ай бұрын
Gr8
@alejandrahorvath 2 ай бұрын
Thanks for watching 😊
@ziggle314 2 ай бұрын
Very useful. Thanks Alejandra!
@alejandrahorvath 2 ай бұрын
Glad it was helpful Mark! Thanks for watching 😊
@mathewrtaylor 3 ай бұрын
As always, great video, and learned something new! Question though, what would the impact be of using a list buffer in the nested monthly lists? Would it help or hinder?
@alejandrahorvath 3 ай бұрын
Thank you Mathew, Great point! In this example, it doesn't seem to make a difference; however, in my experience with longer datasets, using List.Buffer can have a big impact reducing the time calculating & loading. Just keep in mind that you will be impacting the use of memory, when using List.Buffer or Table.Buffer. Here is how the code would look for this video, using List.Buffer for nested tables: let Source = Excel.CurrentWorkbook(){[Name="Demo1"]}[Content][[Date], [Daily Sale]], SOM = Table.AddColumn(Source, "Start of Month", each Date.StartOfMonth([Date]), type datetime), Grouped = Table.Group(SOM, {"Start of Month"}, {{"SOM", each let a = Table.AddIndexColumn (_, "I", 1), x = List.Buffer(a[Daily Sale]), b = Table.AddColumn(a, "YTD", each List.Sum (List.Range(x, 0, [I] )) ) in b}}), TblsCombine = Table.Combine (Grouped[SOM], {"Date", "Daily Sale", "YTD" }), CT = Table.TransformColumnTypes(TblsCombine,{{"Date", type date}, {"Daily Sale", Int64.Type}, {"YTD", Int64.Type}}) in CT
@kebincui 3 ай бұрын
Excellent as always. Thanks Alej ❤
@alejandrahorvath 3 ай бұрын
Thank you Kebin! Glad you enjoyed it! 😊
@franciscom.paredesarias2356 3 ай бұрын
Hola, Alejandra … Muchas gracias por la solución. Algo que generalmente en Excel solemos ocupar, pero que llevarlo a PQ es mucho mejor.💯 Saludos, Alejandra!!!
@alejandrahorvath 3 ай бұрын
Hola Francisco!!! Sí, claro que dependiendo de las necesidades de cada escenario, Excel o Power Query pueden ser la solución ideal. En lo personal Power Query ha sido la mejor 😊 Un abrazo 🤗
@ziggle314 3 ай бұрын
Thanks Alejandra! Great work.
@alejandrahorvath 3 ай бұрын
Glad you liked it Mark! Cheers😊
@carlosraziel7141 3 ай бұрын
Que gusto me da verte de regreso, Ale!! Agradezco y valoro mucho tus aportes, he aprendido mucho con tus videos. Ultimamente me he dado cuenta que cada que trabajo con tablas, hay ciertas rutinas que termino realizando con frecuencia del tipo: Elimina columnas Vacias, transforma a null los campos vacios, transforma a mayusculas los titulos de las columnas, etc. Te pasa lo mismo?, Sería lindo un video con las normalizaciones más comunes :)
@alejandrahorvath 3 ай бұрын
Hola Carlos, muchas gracias! Me alegra que encuentres los videos útiles. Muchas gracias por la fantástica sugerencia. Saludos 😊
@luismiras6481 3 ай бұрын
Alejandra !!! genial, genial, esta semana me puse a pensar en lago asi que hiciera la suma dia a dia (lo necesito mes a mes). Muchas gracias por la generosidad de compartir tus conocimientos. Gracias. Saludos desde Mendoza-Argentina.
@alejandrahorvath 3 ай бұрын
Hola Luis!! Que gusto me dá saber que has encontrado este video de utilidad, me encanta compartir y saber que ayuda lo que comparto. Un fuerte abrazo hasta Mendoza-Argentina. 🤗 Si te hes posible asistir, nos vemos el martes de PQ. 😊
@nsanch0181 3 ай бұрын
Thank you Alejandra for the great power Query Example.
@MarcoMagal 3 ай бұрын
Very nice. I never had the needed to use that, but I found a nice workaround.
@alejandrahorvath 3 ай бұрын
I'm glad you liked it. Thank you for watching!
@luismiras6481 3 ай бұрын
Alejandra, impecable !!! no te imaginas lo que se siente de este lado de la pantalla. Gracias. Muchas gracias. Cuanto te admiro.
@alejandrahorvath 3 ай бұрын
Muchísimas gracias Luis!!! Me alegra que te haya gustado. Aprecio muchísimo tu soporte y como decimos en México, esas porras que siempre me echas, me motivan muchísimo. Un abrazote hasta Argentina!!! 🤗
@luismiras6481 3 ай бұрын
Alejandra eres sensacional, como disfruto de tus videos. Son especiales y tienes una manera tan pedagogica para enseñar que da verdadero placer aprender contigo. Saludos desde Argentina.
@alejandrahorvath 3 ай бұрын
Muchísimas gracias por tus palabras tan lindas, no sabes cuánto aprecio tu apoyo!!! Saludos hasta Argentina!!!
@luismiras6481 3 ай бұрын
Alejandra. Impresionante !!! No te imaginas lo útil que me resulta. Muchas gracias. Un cariño grande desde Argentina.
@alejandrahorvath 3 ай бұрын
Hola Luis!!! Me alegra saber que te es de utilidad. Lo grabé en Español también, pero no he terminado la edición 😬. Te mando muchos saludos y un fuerte abrazo hasta Argentina!!! 🤗
@decentmendreams 3 ай бұрын
The topics you cover are always relevant and very instrumental in understanding the basics of PQ. You are like a surgeon of PQ:- Thank you .
@alejandrahorvath 3 ай бұрын
Thank you, glad you like them! Cheers! 😊
@magicub 3 ай бұрын
Always on Point, Gracias Alejandra. I missed you
@alejandrahorvath 3 ай бұрын
Glad you liked it 😊 Thank you 🙏
@rick_. 3 ай бұрын
Very nice! Using IsEven is likely faster than filtering the Name column.
@alejandrahorvath 3 ай бұрын
Nice you liked it! Thanks for watching 😊
@draganstojanovic1 3 ай бұрын
In Excel 365 Table.SelectColumns have only two parameters.
@alejandrahorvath 3 ай бұрын
The third parameter is optional, you won't see it through intellisense until you provide the comma after the second parameter. For more information about Table.SelectColumns, you can check: learn.microsoft.com/en-us/powerquery-m/table-selectcolumns Thanks for watching 😊
@rajeshmajumdar4999 3 ай бұрын
muchas gracias señorita !!!
@alejandrahorvath 3 ай бұрын
De nada Rajesh! Thanks for watching 😊
@ohdjrp4 3 ай бұрын
thanks for this!
@alejandrahorvath 3 ай бұрын
You're very welcome! Thanks for watching 😊
@Hello-bn2yc 3 ай бұрын
Brilliant... Just what I needed. Thank you Alejandra.
@alejandrahorvath 3 ай бұрын
Glad you found it useful! Thanks for watching 😊
@raimundojs9547 3 ай бұрын
Excellent! ¡Perfecto!
@alejandrahorvath 3 ай бұрын
Glad you like it! Thanks for watching 😊
@krisbowen527 3 ай бұрын
I just found your channel and it's so magical. Thanks for sharing. Anyway, can we use this kind of scenario for "get data>folder" ?
@alejandrahorvath 3 ай бұрын
Welcome to the channel! You should be able to invoke a custom function in files inside an specific folder. Just keep in mind that you would need to transform the content of the column "Content" first. Here is what I mean: kzbin.infoqeJZWSy_Beg?si=9d4NnkJoHyju30sR&t=1839
@krisbowen527 3 ай бұрын
Wonderful. Thank you very much for your knowledge kindness.
@paspuggie48 3 ай бұрын
Ooh, I really like this solution. Many thanks for sharing 👌
@alejandrahorvath 3 ай бұрын
Glad you like it! Thanks for watching 😊
@extraktAI 3 ай бұрын
Amazing video Alejandra, thanks a lot! 🙌
@alejandrahorvath 3 ай бұрын
Glad you liked it! Thanks for watching 😊
@luismiras6481 3 ай бұрын
Alejandra no te imaginas la alegria de verte de nuevo !!! Como extraño tus videos . Eres lo mas !!! un abrazo desde Argentina !!!
@alejandrahorvath 3 ай бұрын
Qué gusto saludarte Luis!!! Muchísimas gracias por tus palabras tan lindas, estoy de vacaciones y por eso he podido subir un poco de contenido. Habrá un #MartesDePowerQuery este Martes en el otro canal, a las 7:00PM MDT (10:00PM Argentina), ojalá pudieras acompañárme, pero entiendo totalmente si no te veo en el chat, es muy tarde para Argentina. Aquí te dejo el link, en caso de que puedas conectarte: kzbin.info/www/bejne/jKrHp2qMmLKhpqc Un abrazote hasta Mendoza, Argentina!! 🤗
@kebincui 3 ай бұрын
Super sultion ! 👍
@alejandrahorvath 3 ай бұрын
Glad you liked it Kebin! Cheers! 😊😊
@נועהאורן 3 ай бұрын
I saw a few explanations about removing empty columns in P.Q. but this one makes it the simplest. Thank you.
@alejandrahorvath 3 ай бұрын
Glad you found this tutorial useful! Cheers 😊
@odallamico 3 ай бұрын
Profe un gran saludo. Gracias por compartir esta técnica. La hora de la clase del proximo martes 27, es hora canada?
@alejandrahorvath 3 ай бұрын
Es un placer Oswaldo 😊 La clase del próximo Martes 27 en el otro canal es a las 7:00PM Ciudad de México, 8:00PM Panamá|Colombia, 9:00PM Chile|Venezuela, 10:00PM Argentina. Aquí te dejo el link: kzbin.info/www/bejne/jKrHp2qMmLKhpqc
@odallamico 3 ай бұрын
@@alejandrahorvath Gracias por la aclaratoria, espero poder verla y escucharla. Un gran saludo
@alejandrahorvath 3 ай бұрын
Excelente! Muchos saludos!!! 😊
@joselencinamalgor6548 3 ай бұрын
Hi Ale, I ve try this. Works Fine! That's method evaluates all rows or only the first 1000. ???
@alejandrahorvath 3 ай бұрын
Hi José! It seems to evaluate all rows, I've used it with tables over 8,000 rows and counts all rows. This function is awesome! Un abrazo 😊
@joselencinamalgor6548 3 ай бұрын
@@alejandrahorvath Otro, la probé con 5400 filas! 😎
@alejandrahorvath 3 ай бұрын
👍😊
@mohdmuzammil3059 3 ай бұрын
Thanks this method is absolutely new to my knowledge Thanks giving.
@alejandrahorvath 3 ай бұрын
Glad you found it useful. Thanks for watching 😊
@luigibru8677 3 ай бұрын
Perfectly explained!
@alejandrahorvath 3 ай бұрын
Glad to hear. Thanks for watching 😊
@CeliaAlvesSolveExcel 3 ай бұрын
Awesome, Alejandra! I've done this before using nullcount but I was not aware of the function Table.Profile. I've gained my day with this tip! 😉
@alejandrahorvath 3 ай бұрын
Glad you like it! 😊 Table.Profile is a gem 💎❤️
@arunsaini3340 3 ай бұрын
when next video...waiting
@alejandrahorvath 3 ай бұрын
Now 😊
@mecorowa5642 3 ай бұрын
Was missing you😊
@alejandrahorvath 3 ай бұрын
Thank you! 😊 Work has been busy and I hadn't had a chance to post much.
@qasimjan5258 3 ай бұрын
Welcome back Alejandra.
@alejandrahorvath 3 ай бұрын
Thank you Qasim! 😊 Hope I can post more often, work has been and will continue to be busy, but I miss sharing tips in Power Query & Excel.😊
@alojzlacko4737 3 ай бұрын
Great tip!
@alejandrahorvath 3 ай бұрын
Glad you liked it. Thanks for watching 😊
@alojzlacko4737 3 ай бұрын
@@alejandrahorvath I was looking for that. I needed to change the data types in the particular list of columns and you provided the useful guide. With the small adoption of your approach, I solved my problem.
@alejandrahorvath 3 ай бұрын
So happy to know that you found this video useful! Cheers!