Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Dates breakdown for Countdown

Hi All   Hope you could help   I've been tasked with the breakdown of dates "Review" table to have a breakdown that will show "3 months left until review", "2 months left untl review", "1 month l...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Idrissshatila's avatar
    Idrissshatila
    3 years ago

    Hello ,

     

    try this :

     

    Column =
    IF ( DATEDIFF ( TODAY (), 'Location Expiration Index'[Review], MONTH ) = 3, "3 Month",
    IF (DATEIFF(TODAY(), 'Location Expiration Index'[Review],MONTH)=2, "2 Month", "NO ALERT"

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos!

  • Idrissshatila's avatar
    Idrissshatila
    3 years ago

    hello,

     

    Yes try it like this, there was an error in the typing of the measure :

     

    Column =
    IF ( DATEDIFF ( TODAY (), 'Location Expiration Index'[Review], MONTH ) = 3, "3 Month",
    IF (DATEDIFF(TODAY(), 'Location Expiration Index'[Review],MONTH)=2, "2 Month",

    IF (DATEDIFF(TODAY(), 'Location Expiration Index'[Review],MONTH)=1, "1 Month", "NO ALERT"

Idrissshatila's avatar
Idrissshatila
Icon for Super User rankSuper User
3 years ago

hello,

 

Yes try it like this, there was an error in the typing of the measure :

 

Column =
IF ( DATEDIFF ( TODAY (), 'Location Expiration Index'[Review], MONTH ) = 3, "3 Month",
IF (DATEDIFF(TODAY(), 'Location Expiration Index'[Review],MONTH)=2, "2 Month",

IF (DATEDIFF(TODAY(), 'Location Expiration Index'[Review],MONTH)=1, "1 Month", "NO ALERT"

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thank you so much man!

     

    Could you please point out what the error was previously for me to learn from it?

     

    One last variable to be added for it to be complete

     

    Could I kindly ask for your help one more time?

     



    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Actually, that's how I've done it in the end

       

      Column =
      IF ( DATEDIFF ( TODAY (), 'Location Expiration Index'[Review], MONTH ) = 3, "3 Month",
      IF (DATEDIFF(TODAY(), 'Location Expiration Index'[Review],MONTH)=2, "2 Month",
      IF (DATEDIFF(TODAY(), 'Location Expiration Index'[Review],MONTH)=1, "1 Month",
      IF (DATEDIFF(TODAY(),'Location Expiration Index'[Review],MONTH)=TODAY(), "ALERT", "NO ALERT"))))
      Thank you so much once again, will accept your answer as solution, as wouldn't get there without your help ❤️