Video

Flashing subtitles is not an accessible way to communicate.

Super. I had a very strong need to be able to do this and you solved it. A fellow South African I believe😁

Oh!! that is so smart!! i couldn't have thought of that! thank you so much, sis :) BTW I've missed you a lot. god bless

Hello, the query files do not have the spreadsheets to load or the folder for the path. queries are broken.😢

Why not just drill down & use List.transform followed by List.Union to get merged tables with unique columns?

The methods you used are very good! Thank you very much!

Hello Miss Microsoft. This is a very nice no code solution. Once the Table with old names and new nmes is set than it easy with your solution. Great Job 🙂 By the way , I have subscriped some weeks ago!

i have a problem to combine multiple sheet that have different header to make one table report ? may i direct email file to you? or maybe any tutorial ? kindly help, thank you

You are brilliant!! I was pulling my hair out getting the "Expression.Error: The key didn't match any rows in the table." THANK YOU!

Dear Miss MS, I wanna ask a small question please. @ 8:40 if the source data is a spreadsheet instead of a table what would be the type instead of 'table' i.e. (SalesData as xxxxxx)? Appreciate your response. Thank You.

My main table didnt change dates as per the calendar table.

Excellent vedio on Parameters, Thanks

can ｕ teach me, using power query makes aging report, but the report date can change and source data can update,thz

Thank you so much. Solved my exact problem!

Great video. Like the way you have selected a small dataset, just large enough to demonstrate the principle. Thank you.

Very good! I got that to work but now I have to add logic so that only this only applies to the group of site ids and restarted for each site id. Not sure how to do that yet but will figure it out

Most excellent. Thank you for doing this.

I did this but it didn't work anyway. I also cropped and cleaned, unsuccessfully. 😢

Thank you so much. A very intuitive video. Question though... what if the null values or errors stated at the 950000th row and all the rows in from of me looked ok?

Hi Melisa

3:27 I am a little confused. Why 9 months? I thought we would be shifting it 3 months - from January to April. So why 9 and not 3? Thanks!

Please click here to get the practice file and guide: buymeacoffee.com/missmicrosoft/e/258842

Request for more short videos like this one, they are really helpful and easy to concentrate. Thanks

Why are you not famous? Your videos are way better than many of the people i follow. inshaAllah one day...From Tanzania

Speak slowly please

Excellent video presentation. Watch this video first to get a good understanding of the way Power Query works and the syntax for M Code. Thanks Melissa.

Thanks!

I was struggling to covert from DE to US date format for two hours. You explanation made my day!! Thanks so much

Your Videos are so helpful …. Thank you very much

What if I want to see two months data....

Could you me please I can't fix my on power query

Superb 👌 video Miss

If your fiscal year does not start on January and you would like to create your fiscal quarters, months, weeks according to your fiscal start month, please check out this guide here, it details the steps to create a fiscal calendar, regardless of your fiscal start month or week start day: buymeacoffee.com/missmicrosoft/e/258842

Sweet Voice Loveu

Excellent! It helped me a lot! Many thanks!

You are great!!!! Subscribed