cancel
Showing results for
Did you mean: New Member

## Measure to add afterward values Hello,

I need a measure that sums the "VL" value afterwards the month of the graph.

The "VL" value is a count of lines with some filters.

Example, in May the "SUM" value must be 308 => 139 (Jun) + 96 (Jul) + 73 (Aug)
Example², in Jun the "SUM" value must be 169 => 96 (Jul) + 73 (Aug)

Thanks

1 ACCEPTED SOLUTION  Memorable Member

You should have a date table that has a numeric value for month

you could do

``````Afterwards =
var _sv Selectedvalue(Date[MonthNumber])=

RETURN

Calculate ( [VL], all('Date'), Date[MonthNumber] > _sv)``````

Did I answer your question? Mark my post as a solution! Proud to be a Super User!

Connect with me!
Stay up to date on  Memorable Member

You should have a date table that has a numeric value for month

you could do

``````Afterwards =
var _sv Selectedvalue(Date[MonthNumber])=

RETURN

Calculate ( [VL], all('Date'), Date[MonthNumber] > _sv)``````

Did I answer your question? Mark my post as a solution! Proud to be a Super User!

Connect with me!
Stay up to date on    