Forum Discussion
Adding column when Date is more than 21 days old
Hello. I have a table names Contacts, and I would like to add a new column based upon the values of two other columns.
If the column "Created Date" is older than 21 days from Today, the new column should populate with "Expired". If the column "Created Date" is not older than 21 days, it should return the current value in the Status column.
I have tried IF ([CreatedDate] < TODAY() -21 Then "Expired" ELSE [Status]) and IF ([CreatedDate] < TODAY() -21, "Expired", [Status])
Any ideas?
Thanks in advance.
Anonymous , oh, you need it in PQ. I've provided the DAX. PQ:
if [CreatedDate] < Date.AddDays(DateTime.Date( DateTime.LocalNow()), -21) then "Expired" else [Status]
4 Replies
- ERD
Community Champion
Anonymous , what was wrong with your second try?
cln = IF ( [CreatedDate] < TODAY () - 21, "Expired", [Status] )- ERD
Anonymous , oh, you need it in PQ. I've provided the DAX. PQ:
if [CreatedDate] < Date.AddDays(DateTime.Date( DateTime.LocalNow()), -21) then "Expired" else [Status]