Forum Discussion
Cumulative total, missing month
Hi I have a cumulative total bar chart comparing proposals sent from 2021 to 2022. In September there were no proposals sent. How do you carry accross the same value for August so that September ...
Hi Anonymous
I don't think this can be achieved without the use of a Date Table. Using a Date Table you can slice by [Month Name]Running total 2022 new = COALESCE ( [Running total 2022], CALCULATE ( [Running total 2022], ALL ( 'Date'[Month Name] ), 'Date'[YearMonth Rank] = MAX ( 'Date'[YearMonth Rank] ) - 1 ) )
tamerj1
Community Champion
Community ChampionHi Anonymous
I don't think this can be achieved without the use of a Date Table. Using a Date Table you can slice by [Month Name]
Running total 2022 new =
COALESCE (
[Running total 2022],
CALCULATE (
[Running total 2022],
ALL ( 'Date'[Month Name] ),
'Date'[YearMonth Rank]
= MAX ( 'Date'[YearMonth Rank] ) - 1
)
)
tamerj1Community Champion
Community ChampionAnonymous
You can use the [Month Number] column but that won't work in case the blank month is January and you want to return December of the previous year.