Forum Discussion
Second highest date
- 3 years ago
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
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!