Track Time Saved

[Anonymous]

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.

[v-lili6-msft]

hi, @Anonymous 

I'm a little confused by your description, from your screenshot in excel I could see that you want to calculate baseline time of every activity per transaction.

What is your sample data in power bi?

Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,

Lin

[Anonymous]

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.