cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Clark75
New Member

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

I have the following data

Clark75_0-1680306804981.png

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.

 

1 ACCEPTED SOLUTION
Clark75
New Member

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 )

 

View solution in original post

4 REPLIES 4
Clark75
New Member

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
Community Champion
Community Champion

hi @Clark75 

try to add a new calculated column like:

 
NewColumn =
IF(
    [start date] <> BLANK(),
    [start date],
    [completed date]
)

That gave me the output of :

Clark75_0-1680308179055.png

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

 

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]

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors
Top Kudoed Authors