Forum Discussion

EduardoC's avatar
EduardoC
Regular Visitor
5 years ago
Solved

Help with Column based on dates.

Hi! I hope someone can help me with this>   I have two columns: Completion Date and Due Date. I want to add a third column that: If Completion Date is not empty, then New Column = "Completed". But...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, EduardoC 

    please try something like the below.

    the formula is for creating a new column.

     

     

     

    New Column CC =
    SWITCH (
    TRUE (),
    'Table'[Completion Date] <> BLANK (), "Cmpleted",
    'Table'[Due Date] >= TODAY (), "On time",
    'Table'[Due Date] < TODAY (), "past due"
    )

     

     

    Hi, My name is Jihwan Kim.

     

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

     

    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, EduardoC 

please try something like the below.

the formula is for creating a new column.

 

 

 

New Column CC =
SWITCH (
TRUE (),
'Table'[Completion Date] <> BLANK (), "Cmpleted",
'Table'[Due Date] >= TODAY (), "On time",
'Table'[Due Date] < TODAY (), "past due"
)

 

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

EduardoC's avatar
EduardoC
Regular Visitor
5 years ago

Thank you, Jihwan Kim!

 

This is exactly what I was looking for. Never thought of the SWITCH option. I really appreciate it. 

 

Eduardo.