Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
Super User
Super User

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors