How I Calculate Running Totals, Using Power Query

preview_player
Показать описание
Today I want to show you how I calculate running totals with power query, for a table or by category (by month, in this example).

Working file available here:

#MSExcel #PowerQuery #RunningTotals #AlejandraHorvath #Empowered2XL #PowerQueryGirl
  1. Alejandra Horvath
Рекомендации по теме
How to Calculate 0:01:58

How to Calculate Running Totals in Excel

How to Calculate 0:02:25

How to Calculate Running Totals or Cumulative Sum for a Range of Cells in Excel 2016

Calculate Running Total 0:00:26

Calculate Running Total in Excel

How To Calculate 0:07:56

How To Calculate Running Totals In Power BI Using DAX [2023 Update]

How to calculate 0:00:45

How to calculate running totals in Excel Tables

How to calculate 0:00:22

How to calculate Running Totals in Excel

How to Calculate 0:04:14

How to Calculate Running Totals in Excel Tables - Office 365

How to Calculate 0:11:51

How to Calculate Running Total in Excel (Formula, Pivot Table, Power Query)

Calculate the Running 0:00:43

Calculate the Running Total in Google Sheets #shorts

How to Calculate 0:04:17

How to Calculate Running Total in Google Sheets

How to Calculate 0:00:38

How to Calculate RUNNING TOTAL in Excel? #shorts #excel

How To Calculate 0:02:51

How To Calculate Running Total Based On Conditions in Excel

How to Calculate 0:01:00

How to Calculate Running Totals in Excel | MS Excel Tutorials

How to Calculate 0:01:47

How to Calculate Running Totals based on Criteria in Excel - Office 365

The Easiest Way 0:00:26

The Easiest Way to Calculate Running Totals in Excel

How to Calculate 0:10:35

How to Calculate Google Sheets Running Total

How to Calculate 0:00:34

How to Calculate Running Totals or Cumulative Sum | Running Totals in Excel Tables - The Easy Way

How to Calculate 0:03:58

How to Calculate Running Total or Cumulative Sum in Excel - Office 365

Calculate Running Totals 0:01:08

Calculate Running Totals based on Criteria in Excel with SUMIFS Function

How to Calculate 0:01:49

How to Calculate Running Total in Excel

How To Calculate 0:02:16

How To Calculate Running Total Using Cumulative SUM In Excel

Excel Running Totals 0:00:52

Excel Running Totals | Calculate Running Total in Excel

Excel Cumulative Sum 0:03:28

Excel Cumulative Sum Formula | Calculate Running Totals - How To

Quick Analysis Tool 0:00:22

Quick Analysis Tool in Excel to calculate Running Total #excelshorts

Комментарии
Автор

Hola, Alejandra … Muchas gracias por la solución. Algo que generalmente en Excel solemos ocupar, pero que llevarlo a PQ es mucho mejor.💯

Saludos, Alejandra!!!

franciscom.paredesarias
Автор

Alejandra !!! genial, genial, esta semana me puse a pensar en lago asi que hiciera la suma dia a dia (lo necesito mes a mes). Muchas gracias por la generosidad de compartir tus conocimientos. Gracias. Saludos desde Mendoza-Argentina.

luismiras
Автор

Que gusto me da verte de regreso, Ale!! Agradezco y valoro mucho tus aportes, he aprendido mucho con tus videos.

Ultimamente me he dado cuenta que cada que trabajo con tablas, hay ciertas rutinas que termino realizando con frecuencia del tipo: Elimina columnas Vacias, transforma a null los campos vacios, transforma a mayusculas los titulos de las columnas, etc. Te pasa lo mismo?, Sería lindo un video con las normalizaciones más comunes :)

carlosraziel
Автор

As always, great video, and learned something new! Question though, what would the impact be of using a list buffer in the nested monthly lists? Would it help or hinder?

mathewrtaylor