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.
Solved! Go to 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 )
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 )
hi @Clark75
try to add a new calculated column like:
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
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]
User | Count |
---|---|
105 | |
31 | |
27 | |
18 | |
15 |
User | Count |
---|---|
103 | |
22 | |
20 | |
20 | |
18 |