I've been able to connect, this is impressive. Does it contain table information? If not, any plans to add it?

PLEASE HELP! When am trying to expand that Table data custom column, i dont get date within the data set drop list, i get only name & path :\

Amazing thanks again

Thank you! I been looking everywhere and they all just say group by and "All Rows" but that didnt do the job

Miguel, 😢 que pasó con su página web😢

Exactly what I was looking for. Thanks for the upload.

life saver

sinceramente, podrías haber detallado cómo hacer todos los pasos de cara a obtener el informe final en el caso 1 por lo menos. Eso de agregar columnas adicionales y demás... un poco fraude este vídeo.

How do I grab a column from another table into this one

This doesn't work with Direct Query. Any alternative for Direct Query Models?

Great simple solution! I was trying to make is much more difficult than it needed to be. Thank you!😀

Can we do it by DAX method? I mean not to use power query.

thank you!!!

Excellent, thanks a lot

Wow! I spent 8 hours trying to figure out how to extract a "capture Date" out of multiple jpg files (exif not natively supported in excel). I kept looking up vba code and other information to no avail. I knew power query should work. In fact I could get the data I needed by loading any jpeg file individually then converting to a text, then doing some clever formatting of the data (hint, the capture date is always in the 5th row of the text file, at least on my pictures). I couldn't for the life of me figure out how to parse through multiple files though. Your first 3 minutes of the video perfectly explained I could convert my trick into a function to be reused for every file. WOOHOO!!!!!

How do we get rid of duplicate values in the extracted list?

Hello, How did you create the function?

Thank you so much!

BEAUTIFUL! Thank you! 🌞

My take: kzbin.info/www/bejne/apavgmZtqpWVpdE

Two solid days I spent trying to do this. I got a freaky solution but was not at all happy with it. I went down this path but that function thing was the key. This is valuable even 5 years later! Thank you!!

Insightful method to achieve the same requirement. Thank you :)

Hi, i would like to insert a condition in your function, but i don't know what's wrong: This is the code of the function : Could you help me ? (if i have the value "%" i want to do some calculation, otherwise, just add the amount) Thanks Source = Table.RowCount(Table.SelectRows(tAugmentation, each ([Category] = typeAugmentation))), Personnalisé1 = List.Generate ( ()=> [MoisEntree=0,Salaire=SalaireEntree,Taux=0,Categorie=typeAugmentation,Mois=Date.From(DateTime.LocalNow())], each [MoisEntree]<=Source, each [ MoisEntree = [MoisEntree]+1, //He says 'not valid' if tAugmentation{[Index = [MoisEntree]+1]}[Type]>= "%" then Salaire = [Salaire] * (1 + tAugmentation{[Index = [MoisEntree]+1]}[Augmentation]) else Salaire = [Salaire] + tAugmentation{[Index = [MoisEntree]+1]}[Augmentation]

Hi, great work and thanks, but how to get the percentage in the result of the function ? (to display this rate in the table)

i want you see with million rows how you will add all columns names there...

Awesome! you nailed what I need. Thanks.

Hartelijk dank voor je goede uitleg! Het bespaard me veel werk

Hi, Very nice solution. Is it possible to add multiple columns at once?

This is great, I followed your process but I have duplicate rows under "SalesPerson" (User ID) example because I have multiple rows due to other categories. So when I merge and extract values I am pulling duplicate values. Is there a way to group by distinct User ID? hope this makes sense.

Nice explanation, man!

Thanks for this amazing video

perfect, looking all day for this answer and you explained quickly and clearly:)

Fabulous!👍👍

Thank you so much!!

Very useful piece of information. Thanks a lot!

Great video!

Great video!,

Amazing video!!!

To think that I tried to do this task for a week. I could not find anyone talking about in forums. I tried programming, but PBI seems to be particularly awful with for functionality if it even has it. You however had brought exactly what I needed to finish the most annoying second half of my project. I had a very nasty DWH table with relevant data not only in different rows, but columns also. It took an ungodly amount of time and actions just to clean it up properly.

Super Excellent Video!!!

How would you do this with an API that has an endCursor (not an actual page count but a parameter you pass to get to the next page)?

Simply Magic bro, Thanks for this helpful content!!

Excellent Video! This is exactly what I was looking for and needed. Thank you very much.

It's very valuable information and understandable very clear thank you

Thank you, very good.

Hey - this is an excellent lesson. I was wondering if the same technique could be modified to return the bottom 3? would these work : 1. If we sorted sales in Ascending order? or, 2. If we changed the FirstN parameter to -3, for example? Or, 3. Is there a BottomN equivalent in M?

Hey - this is a great video indeed and I am finding this most effective amongst the others available on the net. The problem with the code is however that it is not replacing the text strings which have multiple strings, sometimes separated by space and sometimes separated by comma. Is there a workaround for that?

This is exactly what I want to do, but my input is not table but Binary, can I do the same if this is the case? I have want to preserve the folder path column when expanding all the binaries