cancel
Showing results for
Did you mean:
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

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

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

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

## Re: Need Help

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 ".