5 Power Query Tips including Filter Ignoring Case and Rename Steps without waiting

[@reemAlosherey]

Extremely helpful!! Thanks for sharing these tips 🙌🏽🙌🏽🙌🏽

[@AccessAnalytic]

You’re welcome.

[@FsoOmar]

Awesome tips. The new ones to me: 1- End of Week Day, and 2- Bringing back the formula wizard. Even the tips I knew, I've already forgotten them. 😅 Thank you Wyn. 🤝 👏

[@AccessAnalytic]

Cheers for taking the time to let me know you found it useful

[@mirrrvelll5164]

Neat and precise. Like it =) Especially this ignoring case.

[@AccessAnalytic]

Cheers

[@mohammedelsakally540]

Thank you for the nice tips,,, we are looking for this type of tips all time, so we are waiting more from tips and tricks from you.

[@AccessAnalytic]

You’re welcome.

[@sledgehammer-productions]

Awesome. And whenever I see that word, I now hear it in your voice 😀

[@AccessAnalytic]

😆

[@Oprimaita]

Absolutely perfect ! Thanks a lot.

[@AccessAnalytic]

You’re welcome.

[@shoaibrehman9988]

Gr8 tips will be very useful. Could you pls add some more.

[@AccessAnalytic]

Great. Here’s a couple of older video kzbin.info/www/bejne/epDLgoSLmseDr6M kzbin.info/www/bejne/gKjXpGaArq92hNUsi=u1pyOQri9Ocios0P

[@chahineatallah2636]

Great tips as usual, I hope to remember them when I need them 😀, at least filter I won’t forget it as it’s the most one that I use 😀

[@AccessAnalytic]

Thanks, yes I often refer to these videos as I forget all the time!

[@nevermore17011990]

nice trick as always mate.

[@AccessAnalytic]

Thanks 🙂

[@baskis69]

Super tips¡¡¡, Thanks for sharing

[@AccessAnalytic]

No worries, I appreciate you taking the time to let me know you found it useful

[@Hello-bn2yc]

Brilliant

[@AccessAnalytic]

Thank you

[@RPApapq9038]

Awesome!

[@AccessAnalytic]

Cheers !

[@satishchaurasia84ya]

Awesome 👍 tricks. I have a question whenever I add a new column need to make convert column format as text. Can you please let ke know how to set as text for new columns too? Actually I make a monthly report with every month so i. This case add a column for next month and than convert as text for do some calculation.

[@AccessAnalytic]

Normally if having multiple months across columns I would be unpivotting them into a single column for easier use in analysis. Is that something you want to avoid?

[@satishchaurasia84ya]

@@AccessAnalytic No I am not avoid. I m using unpivot for sum but before unpivot need to convert column as int. If any steps to do for get auto all columns and set as int when I add a new column in existing table? Sorry in my query I used text.

[@AccessAnalytic]

I haven’t seen a good method for doing this yet. I would do my calculations after Unpivotting

[@SamehRSameh]

When pivot column and some column not contain value give me errors, how can i save columns that not contain value??

[@AccessAnalytic]

Maybe this video will help kzbin.info/www/bejne/iqvZaJ2Qbrydd68