how to calculate next month's value?

[illusionek]

Hi

I have a simple table example below

I am trying to get next months value i.e. for product X in 01/10/2014 I would like to get 20 which is value from 01/11/2014

Can anyone help please?

I tried Calculate(Sum(Product No),NextMonth(Date)) and few other Dax formulas like ClosingBalance etc and nothing works. I am sure I am making some silly mistake here but cannot figure this out.


Product No| Date|Qty
X|01/10/2014|10
Y|01/10/2014|15
Z|01/10/2014|11
X|01/11/2014|20

 

[illusionek]

Any help please?

 

[RoryA]

Cross-posted: PowerPivot - how to calculate next month's value?

 

[illusionek]

Well, I posted it somewhere else after couple days, since I can't fix it myself and not getting much luck here. What's wrong with that?

 

[RoryA]

See rule #10 here: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

Pretty much all Excel forums have similar rules - if you read the link in rule 10, you'll understand why.