cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rodrigomocca
Frequent Visitor

Daily average

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?

 

3 REPLIES 3
ricardocamargos
Continued Contributor
Continued Contributor

Hi @rodrigomocca,

 

Could you provide some data as sample ?

 

Thanks,

 

Ricardo

Any ideas?

Yes, of course.

 

2018-02-22_11-29-24.png

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.