Forum Discussion

jip3134's avatar
jip3134
Regular Visitor
1 year ago
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...
Need Help
  • jip3134's avatar
    jip3134
    1 year ago

    this works fine

    Dynamic_Warranty_Date = CALCULATE(
    MAX('CMDB'[Warranty expiration]),
    FILTER('CMDB', 'CMDB'[Warranty expiration] > TODAY())
)
Ashish_Mathur's avatar
Ashish_Mathur
Super User
1 year ago

Hi,

Try this measure

Dynamic_Warranty_Date = CALCULATE(SUM('CMDB'[Warranty expiration]),filter('CMDB','CMDB'[Warranty expiration] > today()))
jip3134's avatar
jip3134
Regular Visitor
1 year ago

Hi

Unfortunately, it doesn't works

If i use you measure in another table, i have strange the result below