Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

3 month date warning

Hi,    I have two dates in my data table, one is the actual date and the other date is an expiry date for approval.  I want the table to show me that when there is a 3 month difference between the...
Data Protection
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-xulin-mstf's avatar
    v-xulin-mstf
    5 years ago

    Hi Anonymous,

     

    I didn't change my original measure, I just changed the icons.

    If you still have some question, please don't hesitate to let me known.ā€Œā€Œ

     

    Best Regards,

    Link

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

Fowmy's avatar
Fowmy
Super User
5 years ago

Anonymous 

You can create  a measure as follows:

Warning = 
var __diff = DATEDIFF(MAX(Table4[Delivery Date] ) , MAX(Table4[Apporval Date]),MONTH )

return
IF( HASONEVALUE(Table4[Delivery Date] ),
    IF( __diff <= 3  , "šŸ”“ " & __diff & " months"  ,"šŸŸ¢ " & __diff & " months"  )
)

 



  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    thank you.

    Is there a way to add amber for the months which are in those 3 months and keep red for all the dates that are way out of the 3 months range. 
    Also how can i sort the results so that all the positives are together and all the negatives are together 

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Fowmy Is there a way to add amber for the dates which are within the three months but keep red for everything that has gone over the date and is expired?

      And to sort it in order