topic Re: Fill NULL date column with date from another column that share same ticket number in DAX Commands and Tips

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

Clark75 — Sat, 01 Apr 2023 00:08:07 GMT

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.

FreemanZ — Sat, 01 Apr 2023 00:07:53 GMT

try to add a new calculated column like:

NewColumn =

IF(

[start date] <> BLANK(),

[start date],

[completed date]

)

FreemanZ — Sat, 01 Apr 2023 00:11:49 GMT

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]

Clark75 — Sat, 01 Apr 2023 00:17:01 GMT

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

Clark75 — Sat, 01 Apr 2023 15:33:52 GMT

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 )