Forum Discussion
Second highest date
You probably get the result your looking for when you use group by and an index column to get an index per group.
In your use case you get an index per serial number. Look at Radacad's explanation on how to do this;
https://radacad.com/create-row-number-for-each-group-in-power-bi-using-power-query
After this step you can use the if function to fill the columns. For example
If index = 1 then initial‐funding date else null
Second funding date column will be
If index = 2 the initialfundingdate else null
Thank you, this helped immensely. However it created a new problem. I now have first, second, third funding dates each in its own column which was my objective, however each one is on a different row.
How can I merge all rows into one showing the serial number, first funding date, second funding date, etc? I tried different methods to no avail.
You can use the group by function from the UI and select MAX on the columns you just created. This columns will either have a value or be null. Choosing MAX will select the value. Now you get the output on one line in your table
Thank you, it worked perfectly!