Selecting Specific Months

[ronman10]

Hi Guys,

I am looking for an expression to select the first 5 months of a particular year, say 2017, in order to show year to date sales. Please let me know how I can get this done.

Regards,

Rony

[sunny_talwar]

May be this

Sum({<DateField = {">=01/01/2017<=05/01/2017"}>}Measure)

[nitin_01]

or may be this if it needs to be dynamic :

vFirst=YearStart('DateField',0,1);

vFifth=YearStart('DateField',0,5);

Regards,

Nitin G.

[ronman10]

Hi Sunny and Nitin,

I am still not able to get this. Let me check where I am going wrong and get back.

Thanks,

Rony

[sunny_talwar]

What is your datefield format?

[sunny_talwar]

May be this can help

Dates in Set Analysis

[ronman10]

It is as you mentioned above. 01/01/2017<=05/01/2017.

Thanks Sunny. I will check this out.