How calculate average for previous month and previous year?

[aignn]

Hi all!

Please help me.

I have table with 20000 rows.

Every row have column Datetime  and Minutes.

I want get average Minutes for previous month and previous year from 01.10.2019.

1. Previous Month (01.09.2019 -01.10.2019)

2. Previous Year (01.10.2018 - 01.10.2019)

How to do it right? Thank you advanced

[Anonymous]

HI @aignn,

AFAIK, current you can't direct aggregation on date or time values, I'd like to suggest to take a look at the following blog to know more about convert DateTime values and calculate:

Aggregating Duration Time 

Regards,

Xiaoxin Sheng

[TomMartens]

Hey @aignn ,

please let me direct you to this side: https://www.daxpatterns.com/time-patterns/

Regards,

Tom