topic Re: If statement with date custom dimension in App Development

If statement with date custom dimension

usr1 — Wed, 11 May 2022 13:56:10 GMT

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!

rwunderlich — Wed, 11 May 2022 14:47:40 GMT

Can you use your expression as written (with parens added)

If( Year([Date]) = 2022, 10, 5)

usr1 — Wed, 11 May 2022 15:09:54 GMT

Unfortunately that does not work in that format

vinieme12 — Wed, 11 May 2022 20:39:13 GMT

As below

=If( Year(max([Date])) = 2022, 10, 5)