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

    • 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?

    • 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

         

    • dgosbell's avatar
      dgosbell
      Advocate I
      10 years ago
      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.