Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Track Time Saved

I have a column called 'Operation' where I just need the values of Create or Update.

I have another column called 'Entity' where i Just need Acct, Opp, CMVproject, and Contact.

From these values, I have the information for time saved. 

In Excel, I would easily just do a calculation, but I am not sure how to translate into Excel.

I have attached reference pictures.

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      My PowerBi data is in the above screenshot.

      I need the # of create/update values with the entity equal to acct/opp/appt/cmvproject. From there I would need the average time from each of these values.