Create Max Date Columns based on multiple columns (some with blanks)

Hi  BA11501Banderso ,

Here are the steps you can follow：

1. Enter PowerQuery and copy the Table to form Table2.

2. Select all columns in Table2 except [Notification] - Transform - Unpivot Columns.

Result:

3. Create calculated column.

Table2:

max_date =
 MAXX(FILTER(ALL('Table2'),'Table2'[Notification]=EARLIER('Table2'[Notification])),[Value])

Table:

Max Date Columns =
MINX(FILTER(ALL('Table2'),'Table2'[Notification]=EARLIER('Table'[Notification])),[max_date])

4. 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