Forum Discussion
michellefs_br
Helper I
Helper IRunning Totals in Query Editor
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 t...
Sean
Community Champion
Community Championmichellefs_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_brHelper I
Helper IThey 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
Community Admin
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
