help for dynamic measure with date

jip3134

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 called "Warranty expiration" (it is in a date format) and it is in this format : mardi 25 mars 2025

I have created the DAX measure below but it does'nt works

Dynamic_Warranty_Date = 
CALCULATE(
    SUM('CMDB'[Warranty expiration]),
    'CMDB'[Warranty expiration] > NOW()
)

Could you help please?

Chewdata

Hey,

Creating a column in Power Query might be a better approach:

= Table.AddColumn(#"Changed Type", "Warranty expired", each if [Warranty expiration] <= Date.From(DateTime.LocalNow()) then true else false)

You can then filter on this column

Or if you want to use a calculated column instead:

Warranty expired =

IF(

YOURDATA[Warranty expiration] <= TODAY(),

TRUE,

FALSE

)

jip3134

sorry but i need imperatively to use power bi

jip3134

Hi

I have already done this and it changes nothing

help for dynamic measure with date