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