Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Jagdish Jha]

Hi community,

I have a survey data with time taken to complete the survey. I am trying to plot this information to show what is the average, max and min time taken to complete the survey. I want to create measure in power bi but I couldn’t find sample DAX formula for this.

Any help will be much appreciated.

Regards,

Jag

[Tuhin Tapadar]

Hi Jag,

Based on your requirement, what I understand that you have to plot time on one axis and max, min avg etc measure on the other axis. And to achieve so you need to calculate the time difference between the start and end time which you can achieve through a calculated column. 

E.g. Start time 10:45 AM, End time 11:05 AM so the time taken to complete the survey is 11:05 – 10:45 = 20 mins etc. You do it for every survey and then plot them against the ‘Completion time’. 

Here, you do not really calculate any time intelligence calculation at all.

Regards,

——————————
Tuhin Tapadar
Data Analyst
Dublin
894164048
——————————
——————————————-

[Ibrahim Badaru]

Hi Jag,

As mentioned by Tuhin, I also believe this is not a time series analysis you want to accomplish here. Now if I understand your need clearly, the average, max, and min you are looking for is the aggregated value based on the computed time taken. If my assumption is correct then you could create something like this:

However, this may not give you the expected output. What I did in the alternative is to convert all time to ordinary number, and calculate MIN, MAX, AVERAGE from the new field, and here’s what I get:

Hope this help!

——————————
Ibrahim Badaru
8172743795
——————————
——————————————-