topic NewBie - Create new column that fills blank dates based on matching "order numbers" in DAX Commands and Tips

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

Anonymous — Wed, 24 Jul 2024 01:42:02 GMT

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

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

FreemanZ — Thu, 25 Jul 2024 06:08:33 GMT

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:

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

Anonymous — Thu, 25 Jul 2024 14:02:12 GMT

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