MTD is not working using the 0/1 indicator

Answered

Comments

2 comments

  • Avatar
    Assaf Fraindlich

    This indicator marks all the days throughout the time dimension that are smaller than today.

    If you wish to see what happened last month, for instance, you need to add a filter for last month on the Date field. This way you will see last month with all the days that are smaller than today.

     

     

     

    0
    Comment actions Permalink
  • Avatar
    Andrew Block

    OJ,

    You could try using this case statement for MTD:

    CASE
    WHEN date <= now()
    AND getmonth(Date) =getmonth(now())
    AND getyear(Date) = getyear(now()) THEN 'MTD'
    ELSE null
    END

     

     

    0
    Comment actions Permalink

Please sign in to leave a comment.