on ‎2018 Nov 27 7:48 PM
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 ?

Request clarification before answering.
Hi jacob.stark Hi christina.obry - do you have any comments on this ? cheers, H
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 12 | |
| 9 | |
| 7 | |
| 5 | |
| 4 | |
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.