Search:

Type: Posts; User: gavs73; Keyword(s):

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    0
    Views
    381

    PowerPivot can't complete import

    Hi, would appreciate any help on this...

    I have a PowerPivot which imports 1,988,837 rows from an external connection, it gets to 1,980,000 but doesn't complete.

    I'm running 64bit Excel with...
  2. Thread: Edit Links

    by gavs73
    Replies
    0
    Views
    115

    Edit Links

    Hi

    I'm trying to update a spreadsheet with a lot of external links, I've tried to do it using the Edit Links button but it just hangs.

    I'm now trying to do it on another offline machine by...
  3. Thread: Getpivotdata

    by gavs73
    Replies
    5
    Views
    208

    Re: Getpivotdata

    Sadly not, but I appreciate you trying for me.
  4. Thread: Getpivotdata

    by gavs73
    Replies
    5
    Views
    208

    Re: Getpivotdata

    Hi Rory, C2 = 2018 and C1 = 1, I've also tried '2018 and '1 and 2.018E3
    I've tried "[Subscriptions].[Start Fiscal Year].&["&C2&"]" , "[Subscriptions].[Start Fiscal Year].&"&C2 , ...
  5. Thread: Getpivotdata

    by gavs73
    Replies
    5
    Views
    208

    Getpivotdata

    Hi

    Would appreciate any help with this GETPIVOTDATA, I need to make it dynamic, and link &[2.018E3] to a year in a cell and&[1.] to week in a cell. I've tried a few things but nothing is working....
  6. Thread: {=table(,k1)}

    by gavs73
    Replies
    1
    Views
    117

    {=table(,k1)}

    Hi, would appreciate any help, I'm trying to unpick someone else's spreadsheet, and there is an Array formula {=TABLE(,K1)} with K1 being a date.

    Magically numbers have appeared in the array,...
  7. Replies
    0
    Views
    123

    Excel Changing Link to other Worksbooks

    Hi

    Would appreciate and help and advice.

    I have a file with thousands of links in cells to other workbooks, I need to change the filepath to these links, which I've done with a find and...
  8. Replies
    1
    Views
    1,561

    PowerPivot Sort Multiple Columns

    Hi

    Apologies if it is a stupid question, is there a way to sort two columns in PowerPivot ?

    For example, sort column 1 by High-Low, and then still preserving that sort, move to column 2 and...
  9. Replies
    0
    Views
    151

    Excel Charts for Combinations

    Hi, can anyone please recommend any good Charts for displaying the frequency of combinations ?

    So for example if I had 10products, that's 1e+10 combinations, is there some sort of heat map chart...
  10. Pivot Table - Add this data to the Data Model

    Hi

    Can anyone please advise what the prerequisites are for getting the 'Add this data to the Data Model' tick box on the Pivot Table wizard to appear are ?, sometimes it appears and other times...
  11. Replies
    3
    Views
    2,464

    Excel 2016 Phantom External Links

    Hi,

    Does anyone please have a fool proof method for finding External Links in Excel 2016 Workbooks ?. I've tried searching for them in cells, I've checked conditional formatting, names ranges etc,...
  12. Thread: Excel Pivot MDX

    by gavs73
    Replies
    1
    Views
    202

    Excel Pivot MDX

    Hi

    Would appreciate any help with this, Iím struggling with the MDX trying to calculate BMI ( Body Mass Index = Weight / Height Squared ), as a Calculated Member in PivotTable Tools -> Analyze...
  13. Replies
    2
    Views
    559

    Re: PowerPivot LOOKUPVALUE

    I've also tried this...

    =FILTER(Band[Band],[Revenue]>=Band[Low],[Revenue]<=Band[High])
  14. Replies
    2
    Views
    559

    PowerPivot LOOKUPVALUE

    Hi

    I'd appreciate any pointers on this, I need to look up in PP a value based on a range in another PP Table.

    I want to return 'BAND' based on where Revenue in the first table falls between...
  15. Thread: Cell References

    by gavs73
    Replies
    1
    Views
    113

    Cell References

    Hi

    Hopefully a quick question, is there a way to reference a cell on another sheet using a formula ?, similar to below:

    ="Apr!"&"AB"&Summary!J55

    i.e. trying to get to this but via a formula...
  16. Thread: DAX Variable

    by gavs73
    Replies
    2
    Views
    461

    Re: DAX Variable

    Thank you
  17. Thread: DAX Variable

    by gavs73
    Replies
    2
    Views
    461

    DAX Variable

    Hi, I'm having trouble calling a variable in DAX ( assuming it is actually possible )...

    I have a number of DAX statements similar to this:
    ...
  18. Replies
    2
    Views
    321

    Re: DAX Result in Excel Cell

    Thanks Matt
  19. Replies
    2
    Views
    321

    DAX Result in Excel Cell

    Hi

    Hopefully a quick question, in my PowerPivot I have a DAX calculation:

    S12015:=CALCULATE([Salesx],Data[Month]="22016",Data[PRODUCT]="ixP")

    Is it possible to reference the result directly...
  20. Thread: Countifs

    by gavs73
    Replies
    1
    Views
    244

    Countifs

    https://lh3.googleusercontent.com/AJmoZO1sx2BFTA03U6fvf8qNcXSybE7EpTY3KPH4xcRpAzgdS85t5qC5Q30ATBHQuSYxvzkrpqBweV8YgnwXNeoSGJiGOikay4YDwC7pq-B7-WSkbMtKVPuKzig2VX2W-W90Z4krg5EpmiRRx-S5Ur5Ko3OkkT152O_4-9...
  21. Replies
    1
    Views
    513

    DAX - Segmentation

    Hi I'd appreciate any help on the DAX Query below. I have two tables, the first called 'combined' and the second 'days', these are unlinked. I'd like to segment the Credit amounts in 'combined' by...
  22. Replies
    2
    Views
    385

    Re: Power Pivot / Chart

    Thank you !
  23. Thread: PowerPivot Date

    by gavs73
    Replies
    2
    Views
    382

    Re: PowerPivot Date

    Thanks Ozeroth
  24. Replies
    2
    Views
    385

    Power Pivot / Chart

    Hi

    If I have a large number of values that I'd like to categorize by bands, e.g. 0-250. 250-500, 500-1000.

    What is the best way to approach that it PP ?

    Thanks for your advice.

    Gav
  25. Thread: PowerPivot Date

    by gavs73
    Replies
    2
    Views
    382

    PowerPivot Date

    Hi

    I'm trying to enter a calculated Date field in PowerPivot but I am getting an error message, I'm not sure why.

    I can get a breakdown of the date components...
    ...
Results 1 to 25 of 102
Page 1 of 5 1 2 3 4