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
Icon for Super User rankSuper 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"  )
)