NewBie - Create new column that fills blank dates based on matching "order numbers"

[Anonymous]

Hi All,

Very new to PowerBi here, covering a colleague who is out sick.

Based on the table below, the table name is: 'OnlineChannel'. I am trying to create a new column based on the column "Scheduled Date" below, the new column will be named "Verified Scheduled Date". The new Column should have no blank values if the "Order Number" has a match in another row with a scheduled date. 

For example, Order Number "20246789" appears 3 times on the table, in lines 8, 9, and 10. The "Scheduled Date" value in line 10 is not blank, therefore all values for Order Number "20246789" in lines 8, 9, and 10 in the new "Verified Scheduled Date" column should match the existing date in line 10.

I have no idea where to start, please help. Thanks in advance!

Line	Order Number	Scheduled Date
1	12395969	1/1/2025
2	14959688	12/6/2024
3	14959688
4	18495768	9/1/2025
5	20241367
6	20241367	1/1/2025
7	20243959	5/15/2025
8	20246789
9	20246789
10	20246789	6/18/2025

[Anonymous · Accepted solution]

It worked like a charm, thank you so very much!

[FreemanZ]

Hi @Anonymous ，

not sure if i fully get you, try to add a calculated column like:

Verified Scheduled Date = 
MAXX(
    FILTER(OnlineChannel, OnlineChannel[Order Number]=EARLIER(OnlineChannel[Order Number])),
    OnlineChannel[Scheduled Date]
)

it works like: