Exclude Year in Measure

[Faiz]

Hi,

I am using below formula to exclude 2016 in the below expression, but it is not working. What is the formula I should use?

SUM ({<[Posting Date.autoCalendar.Year] <> {2016}>} SALES).

Also label has the expression='FACT_VES.Posting Date.Year' and showing 2013,2014,2015 and 2016. How to exclude 2016 from the label expression?

Regards

Faiz 

[Vegar · Accepted solution]

Try this:

SUM ({<[Posting Date.autoCalendar.Year] -= {"2016"}>} SALES).

For dimension try this:

If(FACT_VES.Posting Date.Year<>2016, FACT_VES.Posting Date.Year)