Forum Discussion
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 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?
this works fine
Dynamic_Warranty_Date = CALCULATE( MAX('CMDB'[Warranty expiration]), FILTER('CMDB', 'CMDB'[Warranty expiration] > TODAY()) )
11 Replies
- Chewdata
Responsive Resident
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)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.
- Ashish_Mathur
Super User
Hi,
Try this measure
Dynamic_Warranty_Date = CALCULATE(SUM('CMDB'[Warranty expiration]),filter('CMDB','CMDB'[Warranty expiration] > today()))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.
