Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Coding for 3 month

Hi All   I was wondering if you can help with below    I need to write have a conditional column for 3 month prior to review date   So, I have "review dates" column, and  need something along t...
General Comment
Need Help
Show and Tell
Tutorial Requests
  • Barthel's avatar
    Barthel
    3 years ago

    Hey Anonymous,

    You could add an 'Alert' calculated column to your table:

     

     

    Alert = 
IF ( DATEDIFF ( TODAY (), 'Table'[Reviewdate], MONTH ) <= 3, "ALERT", "NO ALERT" )

     

     

    DATEDIFF calculates the difference between two dates, in this case in months. TODAY returns today as a date. This is updated every time the report is refreshed, making the code dynamic.

    Result:

    ReviewdateAlert

    Sunday, 1 January 2023ALERT
    Wednesday, 1 February 2023ALERT
    Wednesday, 1 March 2023ALERT
    Saturday, 1 April 2023NO ALERT
    Monday, 1 May 2023NO ALERT
Barthel's avatar
Barthel
Solution Sage
3 years ago

Hey Anonymous,

You could add an 'Alert' calculated column to your table:

 

 

Alert = 
IF ( DATEDIFF ( TODAY (), 'Table'[Reviewdate], MONTH ) <= 3, "ALERT", "NO ALERT" )

 

 

DATEDIFF calculates the difference between two dates, in this case in months. TODAY returns today as a date. This is updated every time the report is refreshed, making the code dynamic.

Result:

ReviewdateAlert

Sunday, 1 January 2023ALERT
Wednesday, 1 February 2023ALERT
Wednesday, 1 March 2023ALERT
Saturday, 1 April 2023NO ALERT
Monday, 1 May 2023NO ALERT
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Barthel

     

    Thank you so much for getting back to me!

    This is almost what I need it seems, but I don't need the today's date 

    The ReviewDate column has the dates against which i'd like to go

     

    Could you please advise on how to make it so if its 3 months before the date in ReviewDate column ALERT, otherwise NO ALERT 

    the 

    • Barthel's avatar
      Barthel
      Solution Sage
      3 years ago

      Anonymous 

      What would you want to compare with the review date? 3 months relative to what? Now the calculated column defines review dates which are within the next 3 months from today as 'ALERT'.

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Yes you are absolutely right 

         

        Apologies I have had a very long day

         

        Thank you once again and apologies once again