Would like to see only data from 2019 to today's date

[Maciej29]

Hello,

I'd like to see only data from 2019 to today's date using Set expression.

Date Created

1/12/2015

06/03/2016

12/31/2018

05/05/2019

1/12/2020

Thanks in advance

[Anil_Babu_Samineni · Accepted solution]

When you say set expression, It is difficult to us to understand where you are using?

Dimension Level : If(Year([Date Created])>=2019, [Date Created])

Using Expression : Sum(If(Year([Date Created]>=2019, Measure))

[tresesco · Accepted solution]

Try something like:

Sum( {<[Date Created]={">=MakeDate(2019,1) <= today()"}>} Sales)

[Maciej29]

Anil,

I need both.

Thank you