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.
this works fine
Dynamic_Warranty_Date = CALCULATE(
MAX('CMDB'[Warranty expiration]),
FILTER('CMDB', 'CMDB'[Warranty expiration] > TODAY())
)