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

Need Help

Hi All 

 

i need your help to apply DAX formula to calculate the all Rows duration if " Approved by CC " found on the rows 

 

and if not found DAX do not calculate 

 

i put the 2 table with "Approved by CC " not without this action name 

 

OrdernoActionNameDuration
2Quote Closed 
2Quote Convert to Order(0)days,(00)hours,(00)minutes,(38)seconds
2Initiate MKD Approval(1)days,(01)hours,(01)minutes,(13)seconds
2Allocate Item(6)days,(23)hours,(27)minutes,(32)seconds
2Order Push for delivery(5)days,(04)hours,(48)minutes,(11)seconds
2Order Approved by CC(0)days,(15)hours,(10)minutes,(24)seconds

 

 

 

OrdernoActionNameDuration
0000650241Quote Closed 
0000650241Quote Convert to Order(0)days,(00)hours,(01)minutes,(47)seconds
0000650241Initiate MKD Approval(0)days,(00)hours,(00)minutes,(14)seconds
0000650241Reset Order(1)days,(10)hours,(57)minutes,(41)seconds
0000650241Get Approval Click(0)days,(00)hours,(00)minutes,(29)seconds
0000650241Quote Approved by PM(0)days,(00)hours,(01)minutes,(18)seconds
0000650241Quote Approved by GP(0)days,(00)hours,(52)minutes,(34)seconds
0000650241Quote Convert to Order(0)days,(00)hours,(05)minutes,(32)seconds
0000650241Allocate Item(0)days,(08)hours,(04)minutes,(45)seconds
1 REPLY 1
Community Support Team
Community Support Team

Re: Need Help

Hi @shado26

From your two tables, i find only the first table contains "Approved by CC " in the rows of ActionName column, the second table doesn't, so i use the first table as a test.

Since i don't know how to calculate the duration, i only create a calculated column to show whether the row contains "Approved by CC ".

in the picture below, when the value is larger than 0, it indicates that the row contains "Approved by CC ".

4.png

 

If you have any question, please feel free to ask me.

 

Best Regards

Maggie