a task I've been set as part of a PowerPivot creation
1.Enter the last rep to have sold to the customer URN on the query tab of the PowerPivot. Now there's no query tab for me on powerpivot and as far as i'm aware query was part of a ribbon thats now get and transform which has nothing to do with being able to pull that type of information
I'm pretty confident on my measure ability having created many time intelligence formulas but I'm running around in circles with this one with a pounding headache.
I've pulled the customer to the table, created measure to bring in last purchase date, created measure to show days since last measure among many other value based measures filtering by specific types
I really just need the last salesperson name to be populating the the pivot table
1.Enter the last rep to have sold to the customer URN on the query tab of the PowerPivot. Now there's no query tab for me on powerpivot and as far as i'm aware query was part of a ribbon thats now get and transform which has nothing to do with being able to pull that type of information
I'm pretty confident on my measure ability having created many time intelligence formulas but I'm running around in circles with this one with a pounding headache.
I've pulled the customer to the table, created measure to bring in last purchase date, created measure to show days since last measure among many other value based measures filtering by specific types
I really just need the last salesperson name to be populating the the pivot table