End of year quantity

[mikel_de]

Hi all!

I have a combo chart with Date.autoCalendar.Year as a dimension. The line should represent the stock at the end of each year, i.e. the stock in December. I try to use the following formulas but they do not work:

Sum({<[Date.autoCalendar.Month]={"=Max([Date.autoCalendar.Month])"}>}[Quantity]😞 returns the total for each year

Sum({<[Date.autoCalendar.Month]={'12'}>}[Quantity]😞 returns zero

Can somebody please help with this?

It would also be nice if the line shows a value only when there is data for the entire year. Currently I have Jan 2010 until Mar 2017, so I don't want to see value for 2017 as the year has not finished yet. But this is not a vital requirement.

Thank you!

[zebhashmi]

Try this

Sum({<[Date.autoCalendar.Month]={"=Max(Date([Date.autoCalendar.Month],'MM'))"}>}[Quantity])

[mikel_de]

Hi again!

The short name worked. No idea why 'December' does not. Anyways, problem solved! Thanks for your help!