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?

[Ashish_Mathur]

Hi,

Try this measure

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

[jip3134]

Hi

Unfortunately, it doesn't works

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

[Ashish_Mathur]

Cannot understand unless i see your data.

[jip3134]

Here is the file

https://www.dropbox.com/scl/fi/4fdhxn9bj8ylxxsa74nnr/cmdb.xlsx?rlkey=z2n275p87ftasyxth5e5mvkxr&st=td...

[Ashish_Mathur]

Show the result you are expecting.

[jip3134 · Accepted solution]

this works fine

Dynamic_Warranty_Date = CALCULATE(
    MAX('CMDB'[Warranty expiration]),
    FILTER('CMDB', 'CMDB'[Warranty expiration] > TODAY())
)

[jip3134]

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

[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

[Chewdata]

The calculated column solution is in Power BI itself:

Or if you want to use a calculated column instead:

Warranty expired =

IF(

    YOURDATA[Warranty expiration] <= TODAY(),

    TRUE,

    FALSE

    )

Add this column to the relevant table. Then you can set the filter on this column.

[jip3134]

Hi

I have already done this and it changes nothing