topic Re: Running total with blank dates in DAX Commands and Tips

Running total with blank dates

yazenbarakat123 — Thu, 27 Jun 2024 19:14:18 GMT

I am trying to create a running total Line chart visual for the last 3 years , I have an incident table with a date column (blanks are possible if no incidents that month) connected to a calendar table via date column on a one to many relationship.

my requriments are to create a running total per month and to return the previous months total if there is blanks. however I am struggling having the line stop at the max incident month available in the data set or accounting for the blank by returning the previous month leaving a break in my line chart visual

any help would be gladly appreciated!

Re: Running total with blank dates

Anonymous — Fri, 28 Jun 2024 02:04:54 GMT

Hi yazenbarakat123 ,

I create a table as you mentioned.

Then I create a measure as you mentioned.

Measure = VAR _currentdate = MAX ( 'Table'[Date] ) RETURN CALCULATE ( SUM ( 'Table'[Stock Value] ), FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Date] <= _currentdate ) )

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Running total with blank dates

yazenbarakat123 — Fri, 28 Jun 2024 17:17:24 GMT

Hmm I seem to be running into the same issue where the line cuts off the blank month
The Incidents Table does not have any incidents for the month of may so I connect it to a calendar table