Register
Log In
Unanswered
Home
Dashboards
Power Query
Power Pivot
February 18, 2017
Offline
All,
I need help with an analysis. Attached. The pivot table is grabbing leasing data from a building. It shows the average rent and average rent/sf achieved during each Quarter of the property's opening. These averages are a little misleading only because in any given quarter there could be different units and weird one-off situation. To smooth out the data, I wanted to show the average of the entire property at the specific time period during the lease up (almost like a rolling average but the time period stays fixed at the initial opening). For example, 2nd quarter 2016 would be the average of all rents achieved since the beginning of the lease up (q2 2014) through 2nd quarter 2016. As you'll see i have a table the has the respective $/SF (column K and then in Column N i have averaging those averages which is wrong. But i don't know how to do it right.
How do i do this with manually going into the data ?
See Answer
Dashboards
Power BI
Power Query
April 21, 2015
Offline
Sorry, maybe check yourself also after posting, but no file attached! We can't help this way...... sorry!
Answers Post
Dashboards
Power Query
Power Pivot
February 18, 2017
Offline
Frans Visser said
Sorry, maybe check yourself also after posting, but no file attached! We can't help this way...... sorry!
Really?!? I thought for sure I clicked all the right buttons to upload the file correctly. I'll double check when I get into the office
Dashboards
Power BI
Power Query
April 21, 2015
Offline
What I do after the sequence 'selecting file-click upload-click submit reply' is leaving the item, then come back and then see if the attachment really is in the post I submitted. So a kind of 'final check' after leaving and coming back to be sure it's in my reply or new post. And in your post there is nothing, you can see for yourself!
We wait until we see your contribution!
Most Users Ever Online: 57
Currently Online:
22 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Akshatraj Adig
Liesie Marais
Moet Lewis
Michelle Anderson
Veronica Gallego
krishnaraj r
Dharan Prakash Mishra
Md. Rahman
Lilian Vo
Jane Kumwenda
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
