Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Running Total returns wrong value

Hi all,   I'm trying to figure out the running total quick measures. I've added in the base as the sum of couriers and the field as the start date.    As you can see below, the running totals are...
Help Requested
Need Assistance
Running Totals
  • Anonymous's avatar
    Anonymous
    4 years ago

    Anonymous 

    You need to create a calendar table with distinct dates, and connect that date column to your current created at date. Then you would use the new calendar date in the filter expression. For example, if you data is from 2020 to 2021, try

     

    1. Create a calendar table =Calendar(date(2020,11), date(2021,12,31))
    2. Connect the new date table with Created_At. 

    3. create the measure:

    Measure = calculate(sum(sheet1[value]), Filter(allselected(calendar table), isonorafter(calendar table[date], max(calendar table[date]), desc))

     

     

    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Could you send me a screenshot of your relationships please? 

YukiK's avatar
YukiK
Impactful Individual
4 years ago

This is just test tables. Please adjust according to your model. You can drag and drop a column to another column in a different table

 

Please gives a thumbs up if this is helpful!

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I wasn't able to do a many to one. I don't quite understand relationships so I think I might have to go and read up on it then figure out how to reference the table in the running total.