Forum Discussion

ArchStanton's avatar
ArchStanton
Power Participant
4 years ago
Solved

Simple IF Statement

Hi,

I want a calculated column just to tell me whether the date in a column within the same table is Greater than a speific date:

 

 

I don't want a measure and I don't want this linked to my date table, I just need a column to say "Yes" or "No" thats all.

How do I go about it?

Thanks,

 

Need Help
  • MFelix's avatar
    MFelix
    4 years ago

    Hi ArchStanton ,

     

    You issue is with the date that you inputed try the following metric:

    YTD = IF( 'Cases'[pre_resolutiondate]) > DATE(2022, 3, 31), "Yes", "No")

2 Replies

  • MFelix's avatar
    MFelix
    Super User
    4 years ago

    Hi ArchStanton ,

     

    You issue is with the date that you inputed try the following metric:

    YTD = IF( 'Cases'[pre_resolutiondate]) > DATE(2022, 3, 31), "Yes", "No")