Forum Discussion

Deaviouspeanut's avatar
Deaviouspeanut
Regular Visitor
2 years ago
Solved

Wait Time Calculation

I'm trying to work out wait times and be able to work out average wait times and Graph   I have the table set up with Arrival time and Consultation time see below   I have created a custom ...
Need Help
  • halfglassdarkly's avatar
    halfglassdarkly
    2 years ago

    Oh OK, DATEDIFF is a DAX function used in PowerBI. You're trying to add a 'custom column' in PowerQuery not a 'calculated column' in PowerBI itself. The equivalent function to calculate duration in minutes between date/time in PowerQuery would be Duration.TotalMinutes


    See the solution proposed here: https://forum.enterprisedna.co/t/return-difference-of-two-dates-in-minutes/15174


    Alternatively if your dataset isn't huge then adding this as a calculated column to your table in PowerBI using DATEDIFF is still an option.

     

halfglassdarkly's avatar
halfglassdarkly
Responsive Resident
2 years ago

Oh, that's weird. Are other functions working OK? Ocassionally the intellisense autocomplete prompt might get glitchy and you may need to quit out and reopen. It could just be something contextual if you have other elements in your formula.

 

You're adding this as a calculated column in the same table yes? Not as a measure.

 

Maybe post a screenshot of the formula and any error you're getting.

  • Deaviouspeanut's avatar
    Deaviouspeanut
    Regular Visitor
    2 years ago

    Yes custom Column

    Just realised I forgot to start the Square Bracket with the Minutes

    When created I get

     

     

    Then if I replace the formula of the column previously I just get