Running Totals in Query Editor

[michellefs_br]

I'm really focusing in trying to do the running Totals in Power BI query editor

What I have is basically a Table with count of people by the End Date and another table with a count of people by the start date, I also created a relationship with the start date on both tables, so when the end date, I want to create a new table with a join of both Start and End tables (it's giving me errors because of null data). And once done I want do do the running totals based on the start date minus the end date grouped by per month.

[Greg_Deckler]

Does it have to be Power Query, there are well known patterns for this in DAX:

http://www.daxpatterns.com/cumulative-total/

[michellefs_br]

I've tried that one in DAX and it gives me only the total value and put it on each row

[dgosbell]

---

@michellefs_br wrote:

I've tried that one in DAX and it gives me only the total value and put it on each row

---

You've inserted the calculation as a column. It won't work properly in that context. If you insert the same DAX expression as a Measure it should do what you are after.

[Sean]

@michellefs_br Can you provide a sample of the data in both tables?

And what would be the desired result from that sample?

Also what format are the Start and End Dates?

[michellefs_br]

They both have the same values, a Date and a Count.... the desired result would be that one, but on one table instead of two, so I can do a running total using the start date minus the end date

[miguel]

Hey!

Is there any way that you can provide us with a sample file for us to dig in? I'd recommend doing this as a calculated column with DAX instead of a custom column in the Query Editor (Power Query). You might want to try the EARLIER function too!

[Sean]

(Start - End) Running Total

[Greg_Deckler]

Could you also create a running total in DAX for EndDate Count and then create a date table, relate the date table to both Start and End tables and then create a calculated column in the date table that essentially subtracts the two related columns from one another?