Forum Discussion

paw1's avatar
paw1
Helper I
3 years ago
Solved

latest Timestamp date

Hi Team,   Could you please help me to derive Expected output column from Date1, Date2 columns   Logic: If Date1 is null then Date2 need to consider, If Date2 is null then Date1 need to conside...
Need Help
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi paw1 

    try like:

    column = MAX([Date1], [Date2])

serpiva64's avatar
serpiva64
Solution Sage
3 years ago

Hi,

you need to add a conditional column like this

= Table.AddColumn(#"Changed Type", "Custom", each if [Date2] = null then [Date1] else if [Date1] = null then [Date2] else if [Date1]>[Date2] then [Date1] else [Date2])

If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!