Forum Discussion

Frequent Visitor

7 years ago

Running Total without gaps

Hi, I really hope someone can help. I've been using Dax for a while but I cannot figure out how to make ths work. I have a running total where I'm getting no data inbetween data points like bel...

Frequent Visitor

7 years ago

Hi,

Thanks, I'm getting an error about the number of characters when I paste the table in - what's the best way to share it?

I've limited the table to 200 rows as that's what's needed to illustrate the issue.

Thanks,

Alan

Community Champion

7 years ago

You can share the URL to the file hosted elsewhere (Dropbox, OneDrive... or sites like tinyupload.com, where no sign-in is required)

a_cutler
Frequent Visitor
7 years ago
OK, here's a file with example data.

https://ufile.io/6j0qr

Thanks
a_cutler
Frequent Visitor
7 years ago
AlB Is the above file ok?

Thanks,
Al
- a_cutler
  Frequent Visitor
  7 years ago
  AlB - Apologies, for a little more context of what I'm trying to, I'm looking to produce a table that has the running total of column RunningAgeTotal without the blanks. I'd like to split the table so it has DatepaidoutShort across the top and Breach Month of Contract Col as the rows.
  I've included a picture of the table I'm trying to produce in the file below.
  
  https://ufile.io/onulz
  
  The calculation I'm trying to use below is suming up the runningagetotal column where days to clear is over 30 or is blank and also where breach count col is 1.
  
  Breach Month of Contract Col = CALCULATE(sum('Breach Month'[RunningAgeTotal]),or('Breach Month'[DaysToClear]>30,ISBLANK('Breach Month'[DaysToClear]) = TRUE()),'Breach Month'[Breach Count Col] = 1)
  
  I need to be able to use slicers on the data once it's produced the table.
  
  Please do let me know if you need to know anything else.
  
  Thanks,
  Alan