Forum Discussion

Anonymous

Not applicable

3 years ago

Solved

Conditional custom column based on dates comparison

Hello, I have the following table loaded in Power Query. I am trying to add a new column called "Category" which would have specific text values based on the following conditions: 1. If Action date...

davehus
3 years ago
Hi Anonymous ,

Try the custom column below.

if [Action date] = null then "No Action" else if [Action date] > [End date] then "Late" else if [Action date] <= [End date] then "On Time" else "No Action"

Did I help you today? Please accept my solution and hit the Kudos button.

Memorable Member

3 years ago

Hi Anonymous ,

Try the custom column below.

if [Action date] = null then "No Action" else if [Action date] > [End date] then "Late" else if [Action date] <= [End date] then "On Time" else "No Action"

Did I help you today? Please accept my solution and hit the Kudos button.