Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this
Sum({<DateField = {">=01/01/2017<=05/01/2017"}>}Measure)
or may be this if it needs to be dynamic :
vFirst=YearStart('DateField',0,1);
vFifth=YearStart('DateField',0,5);
Regards,
Nitin G.
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
What is your datefield format?
May be this can help
It is as you mentioned above. 01/01/2017<=05/01/2017.
Thanks Sunny. I will check this out.