Forum Discussion

michellefs_br's avatar
michellefs_br
Helper I
10 years ago

Running 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...
michellefs_br's avatar
michellefs_br
Helper I
10 years ago

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's avatar
miguel
Community Admin
10 years ago

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's avatar
    Sean
    Community Champion
    10 years ago

    (Start - End) Running Total