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

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

Sean's avatar
Sean
Community Champion
10 years ago

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'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