Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago
Solved

Identify Most Recent Date Between Multiple Columns

I get my base from excel and my evaluation is made up of the columns: ID | Ap1 Date | Ap2 Date | AP3 Date I don't know anything about power query and I don't know if I need to know at this point si...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi  Syndicate_Admin ,

     

    Here are the steps you can follow：

    1. In power query – Add Column – Custom Column.

    if [Ap3 Date] =null
then [Ap2 Date]
else if [Ap2 Date]= null
then [Ap1 Date] else null

    2. Select [Ap1 Date], [Ap2 Date] and [Ap3 Date] – Remove Columns.

    3. Result:

     

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  Syndicate_Admin ,

 

Here are the steps you can follow：

1. In power query – Add Column – Custom Column.

if [Ap3 Date] =null
then [Ap2 Date]
else if [Ap2 Date]= null
then [Ap1 Date] else null

2. Select [Ap1 Date], [Ap2 Date] and [Ap3 Date] – Remove Columns.

3. Result:

 

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly