Forum Discussion
Forecast for running total
how to make a running total for each month ? In power bi, I have a table refering the image below contains 12 month per year that only show single month and actual column is value get from summary t...
Dangar332
Resident Rockstar
Resident RockstarHi, Shuuuu
make a seprate table of Month no from date table
newtable = all(date[month no])
and use it in a slicer and don't make relationship with your data model
make a new column in actual spent table
column =
var curr_month = selectedvalue(newtable[month no])
return
sumx(
filter(
CROSSJOIN(
values(date[month no]),
values(actual spent[actual forecast])
),
date[month no]<=curr_month
),
actual spent[actual forecast]
)
