Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

If date is after today

I'm trying to create a Measure that returns '1' if the date is after today and '0' if it isn't. The date field is called 'period_end_date' and it uses the default hierarchy of Year, Quarter, Month, a...
  • judspud's avatar
    7 years ago

    Hi Anonymous 

     

    What is your reason for using a measure rather than a column?

     

    I have used similar code previously to create a column that identifies if the date is before today.

     

    Try creating a column in the table :)

     

    Thanks,

    George