Substract and Average Time

[Anonymous]

Hello, 

I need to know how I can make this on PowerBi: 

• I will receive a template table, so I will apply my measure to it each time I received a new Table
• I need to calculate the difference between two columns, the format is date(mm-dd-yyyy) - hours - minuts. So I need to calculate the difference between my column "Time Started" and "Date Submitted", which means time ended. This column needs to be called "Time Spent"
  Can I rename this column to Time Ended, and it will stay as "Time Ended" even if I change the data source?.

Also, I want to know the time spent per each category of users. So I will calculate the average time, that the user spent. So, it will be the "Average Time" for each category of users. May be I could used a Slicer, it could be nice.

Thank you for your help.

[Anonymous]

Hi @Anonymous ,

In order to better understand your demands and give the right solution, Could you please provide some more specific information? such as your desensitized example data or a screenshot of your desired results?

Thanks for your time and efforts in advance.

Best regards,
Community Support Team_ Binbin Yu

[daXtreme]

Hi @Anonymous 

Since you're new to the forums... Please read THIS first. It'll help you get answers quicker.