Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.
COURSE of the MONTH
14 days, 2 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
average first 4 months - measure - power pivot
Posted on 2016-07-25
Attached is a sales analysis I am working on. On the work sheet called "sales_by_customer" you will find sales revenues for a store with customer refs in the rows and the applicable months in the columns.
I would like to add an additional column using a measure to calculate the four month average revenues for each customer for the months of Jan, Feb, March and April.
Could someone please help me write this measure.
Note: My pivot table is linked to a data model in power pivot so it must be a measure and not a traditional calc field which could be done using excels native features.
Thanks
Mike
trans.xlsx
I would like to add an additional column using a measure to calculate the four month average revenues for each customer for the months of Jan, Feb, March and April.
Could someone please help me write this measure.
Note: My pivot table is linked to a data model in power pivot so it must be a measure and not a traditional calc field which could be done using excels native features.
Thanks
Mike
trans.xlsx
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Suggested Courses
Course of the Month14 days, 2 hours left to enroll
801 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.