Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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]
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
42 | |
33 | |
30 | |
18 | |
18 |