Duration between 2 dates with DirectQuery

[Bajdak]

Hello, 

i need to calculate the duration between two dates. It should be in time or number format.
It should be possible to visualize the average of the Duration.

In addition it should work with DirectQuery.

[marcelsmaglhaes]

Hey @Bajdak 

You need to use the duration functions: Duration functions - PowerQuery M | Microsoft Learn

For example, to take the duration in days you can use:

=each Duration.Days([Date1] - [Date2])

If this posts helps, please mark my answer as a solution! 

Best Regards,
Marcel