Forum Discussion

ArchStanton's avatar
ArchStanton
Icon for Power Participant rankPower 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 ...
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")
ArchStanton's avatar
ArchStanton
Icon for Power Participant rankPower Participant
4 years ago

Brilliant - many thanks!!