I'm trying to get a graph this year to date (2018), but excluding current month. Untill now I have:
IF [Day] < DATETRUNC('month', TODAY())
[Day] >= DATEADD( 'year', -1, DATETRUNC( 'year', TODAY() ) )
then 1 else 0 END
But it looks like he is showing more then just the numbers of this year. Can someone tell me which formula I can use?
Thanks in advance.
Your date>=DATE(Datetrunc('year',TODAY()) and Your Date<=Dateadd('month',-1,Today())