Forum Discussion
Solved
How to replace a value with todays date ?
Hi, I have a list of dates and some of them are presenting as '31/12/2154'. How can I change those rows listed as '31/12/2154' to todays date? So that every time it refreshes, it shows today...
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