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()) )
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
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.