Forum Discussion
Solved
Rolling SUM
I have a column in the table where it is the result of a conditional measure: Act/TTO Backlog = [R Tot '25] + [D Mtly '25] + [Backlog 25] The 3 measures are formed as follows: R Tot '25 =...
Hello GoodMan85
Use this measure
Act/TTO Backlog Total =
IF(
HASONEVALUE('Calendar'[Month]),
[Act/TTO Backlog], -- Return individual values for each month
SUMX(
VALUES('Calendar'[Month]),
[R Tot '25'] + [D Mtly '25'] + [Backlog 25]
)
)Thanks,
PankajIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
Hello GoodMan85
Use this measure
Act/TTO Backlog Total =
IF(
HASONEVALUE('Calendar'[Month]),
[Act/TTO Backlog], -- Return individual values for each month
SUMX(
VALUES('Calendar'[Month]),
[R Tot '25'] + [D Mtly '25'] + [Backlog 25]
)
)
Thanks,
Pankaj
If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
Hi pankajnamekar25,
thank you. It's work.