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()) )
sorry but i need imperatively to use power bi
Chewdata
Responsive Resident
Responsive ResidentThe 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.
Add this column to the relevant table. Then you can set the filter on this column.