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

8 Replies

    • 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

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        10 years ago

        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?