Grouping Data with Power Query скачать в хорошем качестве

Grouping Data with Power Query

Grouping data is a common thing most analyst do. If you use Pivot Tables you are most likely grouping data. You can also group data with the Power Query feature in the Excel Power BI tools, but why would you want to do that if you already have the powerful options in a Pivot Table? Well there are some sophisticated things you can do with grouping in Power Query like further manipulating data within the grouped records. It involves learning M code, the query language used in Power Query. I'm not a guru in M language but I was able to understand some of the basics to do this. If I can learn this, so can you! 🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p 🏫 Excel Training ➜ https://www.exceltraining101.com/p/tr... 📚 Excel Books & Tech Gear ➜ https://www.amazon.com/shop/dough ⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53 ⚙️ Tools: Microsoft Office ➜ https://microsoft.msafflnk.net/rKL0G ⚙️ Tools: TubeBuddy ➜ https://www.tubebuddy.com/et101 📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support! 🎁 If you find these videos useful and want to support my channel go to https://www.buymeacoffee.com/dough #excel #msexcel #doughexcel ~-~~-~~~-~~-~ Please watch: "Convert Table in a PDF File to Excel"    • Convert Table in a PDF File to Excel   ~-~~-~~~-~~-~