Calculate average between two custom fields dates in EazyBI

[Marija Ušakova]

Hi @eazyBI Support

In the columns I want the average time between two dates custom fields that are holding these issues. Delivery date and item received date.

[eazyBI Support]

Hi Maria,

In this case, you could try creating a new calculated member in "Measures" dimension using datediffdays function:

https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-members/mdx-function-reference/datediffdays

Please note also datediffhours and datediffminutes functions to calculate results in hours or in minutes (if appropriate formatting for the custom measure is used)

Martins / eazyBI support