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...
Need Help
  • judspud's avatar
    judspud
    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

judspud's avatar
judspud
Icon for Solution Supplier rankSolution Supplier
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

  • Matthew1900's avatar
    Matthew1900
    Frequent Visitor
    2 years ago

    In my use case, I am using a measure in order to calculate a cumulative forecasted total based on an average run rate and need to conditionally format the line based on the date - in other words, I would like to be able to make the line invisible (white) before today's date and colored after today's date. Thanks for any guidance!