Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have a data that have key in with future date and data. and i would like apply MTD for a KPI object. This is my set analysis
Count({<Day=,Year=, Month=, Quarter=, Week=, Date=, DateNum={">=$(=Num(MonthStart(Max({<Day>}DateNum))))<=$(=Max({<Day>}DateNum))"}>} VISIT_KEY)
Now... after applying this, i dont understand why the MTD is 3 DEC 2017, that is the last record.
I would like to set the MTD, to calculate Month to Date, like now, is Feb 2017, suppose the MTD should be from 1 Feb til today 7 Feb.
How can i get that analysis with the above MTD set analysis?
Rgds
Jim
Why not create a current month flag instead?
If(Month(Date) = Month(Today()), 1, 0) as [DateCurrentMonthFlag], |
And use that in your set analysis?