Forum Discussion
How to replace a value with todays date ?
Hi DynamicsHS ,
Change the measure.
measure = IF ( MAX ( 'Table'[date] ) = DATE(2154,12,31), TODAY (), MAX('Table'[date]) )If I have misunderstood your meaing, please provide more details.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi DynamicsHS ,
Please have a try.
Create a measure.
measure =
IF ( MAX ( table[date] ) = "31/12/2154", TODAY (), table[date] )
Or add a custom column.
if [date] = "31/12/2154" then DateTime.LocalNow() else [date]
If I have misunderstood your meaing, please provide more details.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
I am getting this error:
the date is formatted as a date and not text?
Hi DynamicsHS ,
Change the measure.
measure = IF ( MAX ( 'Table'[date] ) = DATE(2154,12,31), TODAY (), MAX('Table'[date]) )If I have misunderstood your meaing, please provide more details.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
This has worked but values (dates) that are not 31/12/2154 are coming up as todays date? instead of showing their orginal date? e.g. 27/10/2021 is showing as todays date and not just 27/10/2021
just needed to change the dates around to 31, 12,2154 and its worked. Thank you