How does model calculation Restrict function on Current year work

[Former Member]

Hi all

I have created a formula RESTRICT([Sales] , [d/Order_Date]= Current("Year"))

I am using a dynamic date filter, but when consumed in a story the measure does not behave as I expect. I would expect it to select current year - but you need to add a filter to the VIZ on the year. So what is the difference then?

I have attached a picture, The sales KF does not contain any restrict - the other one (highlighted) is the one with the formula described above. There are no filters on time dimension in the VIZ

I could choose a hard coded filter in the restricted KF on the year = 2018, and then it's filtered on 2018.

My question is: How is the intended behavior of the dynamic filter "Current Year" on a time dimension ?

[JohnL]

Hi Rene,

Have you read the section "Dynamic Time Navigation Functions" in the Home > Formulas and Calculations > Restrict and Lookup online help document?

Current() is referring to the current member. You need to have the time / date dimension in a filter.

Its not selecting the current calendar year (2019). That is not supported in the Dynamic Time Navigation Functions.

HTH

John