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 since my question is the following, from the " Transform data" option, make the following evaluation:

1. Create and enter a new column that I'll call "Approval Date"

2. This column must have the following condition--> Bring Date 3, if date 3 is empty it returns date 2, if date 2 is empty it returns date 1

Note: I know I'll be given the option to work it from the "table view", but it is necessary to work on it from "transform data", for multiple reasons, the main one is that there are certain records that are duplicated and I have to group them, by doing this the Ap dates will disappear and I will only stay with "ID" and from this will emanate the "Approval Date".

Thank you very much for your support

  • 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

2 Replies