Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Substract and Average Time

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.

 

2 Replies

  • daXtreme's avatar
    daXtreme
    Icon for Solution Sage rankSolution Sage

    Hi Anonymous 

     

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    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