Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have created a custom dimension that is being used as a filter:
=Year([Date])
The options in this filter are 2022, 2021, etc.
I would like to use the results of the selections in KPI. For example
If( Year[Date] = 2022, 10, 5)
Thanks!
Can you use your expression as written (with parens added)
If( Year([Date]) = 2022, 10, 5)
Unfortunately that does not work in that format
As below
=If( Year(max([Date])) = 2022, 10, 5)