Daily average

[rodrigomocca]

Hi,

I have a table with this columns:

RecordDate | TimeTracked | TeamMember | Activity

I need to get the daily average of time tracked for a user and an activity.

I'm using this measure

CALCULATE(AVERAGEX(VALUES(TimeExport[RecordDate]), TimeExport[TotalTracked]))

but this does not have in account days with no time tracked, this only gives me the average for all days with time tracked.

How can I do?

[ricardocamargos]

Hi @rodrigomocca,

Could you provide some data as sample ?

Thanks,

Ricardo

[rodrigomocca]

Any ideas?

[rodrigomocca]

Yes, of course.