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 ,

 

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!

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi 

    Thank you for getting back to me

     

    I've tried following your advise, and got the below:

     

    Any further help will be greatly appriciated