Forum Discussion
Solved
Issues with Running Total when Entry is blank
Hello everyone, I've been melting my head arround this one and i've tried multiple approaches and non of them seem to be working. I've got this running total formula ContinuousSUM_GM...
Bruno_Soares_25
You model is not clear to me, if you have a separate dates table , why you have named it here as table for both fact and dimension? I am also aware of other fileds added in the visual.
If you have a dates table then the pattern should be:ContinuousSUM_GMV = VAR MaxDate = MAX ( 'dates'[date_diff_imp_sales] ) VAR ContinuousSUM = CALCULATE ( SUM ( 'table'[Revenue] ), 'dates'[date_diff_imp_sales] <= MaxDate ) RETURN ContinuousSUM
although your tables and the relation between them are not clear. but based on my understanding you might have a date table where the column number f days come from. So you might need to use All function on your date table.
if not, please clarify or upload a sample dummy file.
If this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.