Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply

Average task per day

Hi Fam,

I have this table visual where it shows the average task per driver from 4/1/2022 - 4-5/2022. 
How could I get the average task per day per driver in the same table visual? 

1.png

1 ACCEPTED SOLUTION
v-jayw-msft
Community Support
Community Support

Hi @Andrew_na_lang ,

 

The denominator should be datediff +1.

measure = [average task per driver]/(datediff(min(slicer[date]),max(slicer[date]),day)+1)

 

Best Regards,

Jay

 

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

View solution in original post

2 REPLIES 2
v-jayw-msft
Community Support
Community Support

Hi @Andrew_na_lang ,

 

The denominator should be datediff +1.

measure = [average task per driver]/(datediff(min(slicer[date]),max(slicer[date]),day)+1)

 

Best Regards,

Jay

 

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
ryan_mayu
Super User
Super User

@Andrew_na_lang 

pls try 

average task per drive / datediff(min(date),max(date),day)





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.