sort the date

Hi Anonymous,

I'm afraid that should be caused by the context.

You could modify your fomula like below.

VAR dayNo =
    INT ( Calculate(AVERAGE ( 'Task Query'[task_pending_datediff_minutes],ALLEXCEPT('Task Query','Task Query'[Column name])) / 1440 )

Here is an example which may help you understand the difference.

If you still need help, please share some data sample and your desired output so that we can help further on it.

Best Regards,

Cherry