Forum Discussion
Solved
help for dynamic measure with date
Hi I used a static filter in my report in order to filter events after the date of the current day I oblige to update regularly this date So I try to create a dynamic mesure My date field is ca...
this works fine
Dynamic_Warranty_Date = CALCULATE( MAX('CMDB'[Warranty expiration]), FILTER('CMDB', 'CMDB'[Warranty expiration] > TODAY()) )
Show the result you are expecting.
Actually I use a manually filter in my report in order to filter the "warranty expiration" field
I just want to keep events for which the warranty expiration date is after the current expiration date
so i need a measure which do that