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!

v-xulin-mstf's avatar
v-xulin-mstf
Community Support
5 years ago

Hi Anonymous

 

Is this what you want?

Create two measures as:

__diff = DATEDIFF(MAX('Table'[Delivery Date] ) , MAX('Table'[Approval Expiry Dae]),MONTH )
Warning = 
 IF( [__diff] <= 3  ,  [__diff]& " months"  , [__diff] & " months"  )

The demo is attached, please try it.

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!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hiya thanks for the reply, 
    I've tried to use your method however, this is the result i'd like and I am not able to do that, I was wondering if theres a way to add to Fowmy method and adding amber for that range instead 

     

    heres what I've tried 

    this is the dax measure 

    this is what im trying to do but cant add it to yours

     

    • v-xulin-mstf's avatar
      v-xulin-mstf
      Community Support
      5 years ago

      Hi Anonymous

       

      Is this what you want?

      Please try the attached demo.

      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!

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Any chance you could screenshot the Measure as Im waiting for the new update to be approved therefore cannot open the file