topic Re: Calculate if 15 days or greater from a column date, then return "X", otherwise return "Y" in DAX Commands and Tips

Calculate if 15 days or greater from a column date, then return "X", otherwise return "Y"

HaloKay — Tue, 14 Nov 2023 00:16:48 GMT

Hello,

I have a column called "Action Needed" that has alot of If conditions such as if:

[1st letter request date] = blank( ) && [Records received] = Blank ( ), "Request letters"

I am wanting to return a result of "Send 2nd request for letters" if today's date is 15 days or greater from [1st letter request date] otherwise it will be "Waiting on letters" which means it's less than 15 days from today.

I came up with but not sure: [1st letter request date] >= today () - 15 &&, "Send 2nd request for letters", "Waiting on letters"

Thank you in advance!

Re: Calculate if 15 days or greater from a column date, then return "X", otherwise return "Y"

Jihwan_Kim — Tue, 14 Nov 2023 04:07:03 GMT

Hi,

If you aim to create a new column, please try something like below whether it suits your requirement.

new column CC = IF ( [1st letter request date] >= TODAY () - 15 && NOT ISBLANK ( [1st letter request date] ), "Send 2nd request for letters", "Waiting on letters" )

Re: Calculate if 15 days or greater from a column date, then return "X", otherwise return "Y"

HaloKay — Tue, 14 Nov 2023 16:41:00 GMT

Thank you! I needed that NOT ISBLANK. This will help with the other actions I need to calculate.