
Dashboards
Power Query
Power Pivot

February 18, 2017

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 ?

Dashboards
Power BI
Power Query

April 21, 2015


Dashboards
Power Query
Power Pivot

February 18, 2017


Dashboards
Power BI
Power Query

April 21, 2015

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