My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

You are here: Home / Can I refer to a cell in an Excel file in a PowerPivot file|Power Pivot|Excel Forum|My Online Training Hub
Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search|Last Search Results
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
Can I refer to a cell in an Excel file in a PowerPivot file
Avatar
Anne Walsh
Member
Members
Level 0
Forum Posts: 100
Member Since:
May 2, 2014
sp_UserOfflineSmall Offline
1
April 16, 2018 - 7:14 pm
sp_Permalink sp_Print

Not sure if I posted this or not (couldn't find it in the forum if I had). I want to refer to a date that filters a pivot table based on a PowerPivot. I can get this to work no problem in Excel. Basically it checks if a certain date i.e. Revenue date in a column is before or after a cut-off date. If it is before it is "Earned". If it is after it is "Deferred". How can I set this up so that the user just has to enter this date on another cell in the Excel sheet that has the pivot table (based on the PowerPivot file) and refresh. Then they can instantly see at any date what is "Earned" and "Deferred".  Thanks

Avatar
Mynda Treacy
Admin
Level 10
Forum Posts: 4446
Member Since:
July 16, 2010
sp_UserOfflineSmall Offline
2
April 17, 2018 - 9:02 am
sp_Permalink sp_Print

Hi Anne,

This can't be done with Power Pivot. You can do it with Power Query though and I cover this in session 7.01.

Mynda

Avatar
Anne Walsh
Member
Members
Level 0
Forum Posts: 100
Member Since:
May 2, 2014
sp_UserOfflineSmall Offline
3
April 17, 2018 - 10:14 pm
sp_Permalink sp_Print

hi Mynda

That's brill. Will check it out. Thanks. 

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online:
Guest(s) 11
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 870
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
A.Maurizio: 202
Jessica Stewart: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
John Chisholm
vexokeb sdfg
John Jack
Malcolm Toy
Ray-Yu Yang
George Shihadeh
Naomi Rumble
Uwe von Gostomski
Jonathan Jones
drsven
Forum Stats:
Groups: 3
Forums: 24
Topics: 6212
Posts: 27236

 

Member Stats:
Guest Posters: 49
Members: 31888
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen