Fill NULL date column with date from another column that share same ticket number

[Clark75]

I have the following data

I need the completed date on the same row as the start date where the Completed date is null.

Any help will be greatly appreciated.

[Clark75 · Accepted solution]

My final result was to gather the amount of time it took to process a ticket. I ended up doing the following:

BeginDate =

CALCULATE (

    MIN ( Query2[Transaction_Date] ),

    ALLEXCEPT ( Query2, Query2[Wo_Number] )

)

*********************************************************************

Date_Difference =

DATEDIFF ( [BeginDate], [Completed Date], DAY )

[FreemanZ]

hi @Clark75 

try to add a new calculated column like:

NewColumn =

IF(

    [start date] <> BLANK(),

    [start date],

    [completed date]

)

[Clark75]

That gave me the output of :

I need the Completed date on the same row as the start date. Sorry if I did not communicate that correctly

[FreemanZ]

Above is with DAX, or try add a custom column in Power Query Editor like:

column =

if [start date]<>null

then [start date]

else [completed date]