Arreglando Tablas con Power Query: Power Automate | Episodio 3 - Transformación por Agrupación

In this session, we will study the grouping operation, applied as a strategic intermediate step in data transformation. Additionally, we will subtly utilize the M language to arrive at the formatting solution. Furthermore, this session will use Power Query Online via Power Automate, as this scenario requires transformation to feed a Power Automate workflow in the cloud and communicate via Teams. __ SPECIALIZATION IN POWER QUERY AND M LANGUAGE __ https://escueladeinteligenciadenegoci... ------------------------------------------------------------------------------------ │ VIDEO CONTENT TABLE │ ------------------------------------------------------------------------------------ (0:00:00) - Wait (0:04:05) - Introduction (0:07:25) - Power Query, Cross-Platform Technologies (0:10:19) - Real-World Transformation Case Study (0:12:53) - Accessing Power Automate in the Cloud (0:13:46) - Creating an Instant Flow (0:15:40) - SQL Server, Transforming in Power Query (0:19:00) - Diagram View in Power Query Online (0:21:09) - Grouping by Account Code (0:23:59) - Adding an Index Column to "Mini Tables" (0:30:05) - Query Script in Power Query Online (0:33:44) - PowerQueryFormatter.com (0:36:06) - Analyzing Table.AddColumn (0:47:15) - Iteration Functions in M ​​Language (0:51:00) - Table.SelectRows Function (0:58:13) - Calculating Credit with List.Sum (1:01:30) - Posting a Message in Teams Chat (1:03:47) - Testing a Power Automate Flow __ Working Files __ https://www.dropbox.com/sh/zi9hogho2b... __ OTHER POWER BI VIDEOS __ • Power BI with Netflix Data:    • Capacitación de Power BI con Netflix Data ...   • DAX Language from Zero to Warrior:    • Lenguaje DAX en Power BI (Capacitación de ...   • Power Query and M Language:    • Power Query y Lenguaje M con Power BI y Ex...   You can find the Excel Free Blog and stay informed at: — Website | Blog: http://www.excelfreeblog.com/ — Facebook:   / excelfreeblog   — Instagram:   / excelfreeblog   — TikTok:   / powerbi_efb   — Twitch:   / powerbi_efb   #PowerQuery #PowerAutomate #MLanguage THANK YOU. EXCEL FREE BLOG: http://www.excelfreeblog.com/ "Data Analysis and Business Intelligence Using Excel and Microsoft BI: Power Pivot, Power Query, Power View, and Power Map; as well as the Power BI suite (Desktop, Service, Mobile, Embedded, and Power BI Server in the cloud)."