cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
treedgf
New Member

Measure to add afterward values

treedgf_0-1600194081767.png


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
SteveCampbell
Memorable Member
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  
Read my blogs on  



View solution in original post

1 REPLY 1
SteveCampbell
Memorable Member
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  
Read my blogs on  



View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors