cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gco Member
Member

Average

Hi there,

 

I have a table with ProcessDate, Branch Name, and Balance by Branch.  And i am looking to get the average of the balance by branch by process date range.  Can you please tell me how to do it?

 

The process date is a range slicer.

Thank you

 

Glen

1 ACCEPTED SOLUTION

Accepted Solutions
Nathaniel_C Super Contributor
Super Contributor

Re: Average

Hi @gco ,

Drop the The Branch Name on Columns and see measure below for value.

 

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

 

 

branch average.PNG

 

Average Balance = CALCULATE(AVERAGE(Branch[Balance]),ALLSELECTED(Branch[Date]))

View solution in original post

3 REPLIES 3
Nathaniel_C Super Contributor
Super Contributor

Re: Average

Hi @gco ,

Drop the The Branch Name on Columns and see measure below for value.

 

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

 

 

branch average.PNG

 

Average Balance = CALCULATE(AVERAGE(Branch[Balance]),ALLSELECTED(Branch[Date]))

View solution in original post

gco Member
Member

Re: Average

@Nathaniel_C ,

 

You rock!!!  This is exactly what i was looking for.  Millions of thank you for you!!!

 

Glen

Nathaniel_C Super Contributor
Super Contributor

Re: Average

Anytime!

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (2,020)