Forum Discussion

shado26's avatar
shado26
Helper III
7 years ago

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 "Ap...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

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

 

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

 

Best Regards

Maggie