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 the lines of "IF 3 months left before "Review Date" them then ALERT, otherwise NO ALERT"

 

Ideally to have rolling code so I don't have to alter it manually every time dates change 

 

Any help will be greatly appriciated 

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

4 Replies

  • 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'.