powerpivot error

Hi all! I'm desperately trying to get PowerPivot to count the number of 'L's in a column. L itself is a measure, which returns 'L' for stores which have not bought in over a year (and are therefore Lost) and blank for all other cases. When I try the following function...

Hi all, creating a dynamic title for a chart is rather straightforward. Select title box, enter = in formula box, refer to any cell and hit enter. Today I tried this in a Pivot Chart. Since Excel 2013 you can have pivot charts without creating an underlying pivot table (which is new to my...

Hi I am having issues with measures that were built in Powerpivot 32bit. The measures are in the form: Booking_2012:=calculate('vXXXX'[Sum of Bookings],'vXXXX'[Year]="2012") with vXXXX the tab name. I have reopened on the 32bit machine and measures are still valid, but have the following...

I am having trouble combining two different worksheets in one. See the below information: SELECT ['Chef Coats$'].* FROM ['Chef Coats$'] UNION ALL SELECT * FROM 'C:\Users\nlefebvre\Documents\polos.xlsx'.[polos$] I keep getting the error message below, but I don't know what is wrong with the...

When I try to launch the Powerpivot window from a new spreadsheet I get the following error: "Unable to connect to the Analysis server. The server name '$Embedded$' was not found. Please verify that the name you entered is correct, and then try again." I can open the Powerpivot Window in an...

I just bought Bill Jelen's PowerPivot Book, and so far so good, however, when I tried using my own tables to link two tables by Property Name, i continue to get PowerPivot Error - "The relationship cannot be created because each column contains duplicates values. Select at least one column that...