Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Power Query in Excel refreshing after small changes in queries and very slow

    All,

    If I even change a name of a query or something in the last step, the query refreshes all previous queries and it's very slow. Is there a way to stop this behavior that doesn't result in me...
  2. Trying to get a Net Sales rollup in PowerPivot

    I have a PowerPivot table similar to the following (obviously thousands more lines):

    <tbody>
    P&L Category
    Amount
    Something else I may Pivot on


    Sales
    100
  3. PowerPivot FILTER() not working as expected for filtering Pivot Table

    I have a table that has a bunch of =SUM()/CALCULATE Calculated Fields. Items like:


    Total Gallons:=SUM(MasterData[Net Quantity in GAL])

    Total Gallons YTD:=CALCULATE ( [Total Gallons],...
  4. Can't refresh column filter in Pivot Table through VBA

    I am trying to use the following macro to automatically update a pivot table when something changes (just the barebones changes below) :



    Dim pf As PivotField
    Dim pt As PivotTable


    Set pt...
  5. Replies
    0
    Views
    115

    VBA to refresh all pivot caches

    I have the following code to refresh a bunch of pivot table caches. For whatever reason, everytime I save and increment the file, the caches keep pointing back to the old file. I can get this to...
  6. Order of Columns and Rows in PowerPivot does not translate to the version on the spreadsheet

    I have a PowerPivot file where I have Power Query sort by date before entering PowerPivot. Then in Powerpivot I have added calculated columns, a few of which I moved to be in earlier parts of the...
  7. Re: DAX Formula for a suggested value - would use index/match if not using DAX

    Many thanks to both of you - both seemed to work but I went with the one without the index just to avoid the column. I know sometimes an index is useful so I'll think of some other ways.
  8. DAX Formula for a suggested value - would use index/match if not using DAX

    I am trying to recreate much of a clunky spreadsheet that suggests item numbers for products that didn't have item numbers. One calc performed in Excel is an Index/Match within same table. I...
  9. Replies
    2
    Views
    715

    Re: DAX formula - Cumulative Count

    That did it, many thanks. Don't have a great understanding of the EARLIER formula, and definitely had no idea you could even do a 3 item equality check like that.
  10. Replies
    2
    Views
    715

    DAX formula - Cumulative Count

    Hello,

    I am trying to do something like this: I have a column with names of cities:

    Richmond
    Cleveland
    Cleveland
    Boston
    Cleveland
    Boston
  11. Bring a particular modeled table in PowerPivot to life as a values only table in Excel

    All,

    I have a Power Pivot Data Model built to calculate aspects of a P&L by product and customer. There is a working Excel file where exporting the data in a table format as a values only table...
  12. Handing Time Intelligent FCST vs ACT in Power Query/ PowerPivot

    Hello all,

    I am trying to handle an issue with running forecasts. Essentially I drop a bunch of data into a few tables, much of it overlapping in months - meaning that when I drop a new actual...
  13. Replies
    2
    Views
    278

    Re: VBA Code for type casting arrays

    Do you mean manually or with code?
  14. Replies
    2
    Views
    278

    VBA Code for type casting arrays

    Hello,

    I have an array that I am unpivoting data for entry in Power Pivot. For some of the rows, I can merely copy and paste the row quickly using a range. I use the code to transfer the array...
  15. Re: Use Power Query to change one column based on criteria in two columns.

    Thanks - that's what I did per my comment above, but was looking for a better way - because of all the changes, the M code is really long and clunky.
  16. Re: Use Power Query to change one column based on criteria in two columns.

    Probably a clunky solution, but I guess I could do something like:

    1) Setup a temp column
    2) Use the formula =if [Customer Name]="Acme Corp" and [Ship To City]="Cleveland" then [Customer Name]...
  17. Use Power Query to change one column based on criteria in two columns.

    Hello all,

    I have an issue where I have to rename some customers based on some silly historic changes that were overwritten. In Power Query, I'd like to do the following:

    1) Check two columns...
  18. Re: Can't remove table from data model in Power Pivot, says I need to use Power Query

    Actually I didn't see that and that was exactly what to do - many many thanks for that easy solution!
  19. Can't remove table from data model in Power Pivot, says I need to use Power Query

    Hello,

    As the title says, I have a few tables I previous added to the data model, but I no longer want them in there. When I try to do so, it tells me to use Power query, where I originally...
  20. Is there a way to bind a macro to Ctrl+-. or Ctrl+, ?

    As the post says, I'd like to add Increase and Decrease decimal to those keys, though I'm being told I can only bind to letters. Is there a way around this? If not, are there a few shortcut keys...
  21. Replies
    6
    Views
    2,180

    Re: Excel VBA write as text to cell

    Thanks for your time Norie. I need to learn this way of coding, I don't have experience with the "With" statement. Thanks again for your help.
  22. Replies
    6
    Views
    2,180

    Re: Excel VBA write as text to cell

    Oh ok, I misunderstood. I thought you meant to physically select the column and set it to text before running the macro. As a VBA novice it had not occurred to me (though I guess it should have)...
  23. Replies
    6
    Views
    2,180

    Re: Excel VBA write as text to cell

    That works but what if the worksheet is created from scratch, meaning that when I run the code, I kill the old worksheet then have the code create a new one.
  24. Replies
    6
    Views
    2,180

    Excel VBA write as text to cell

    Very simple question I can't find the answer to. I am simply writing a long array to a group of cells:



    For i = 1 To UBound(itemArray)
    Cells(i, 1).Value = itemArray(i)
    Next


    itemArray...
  25. Doesn't Power Query pick up Union Queries in Access?

    I created a simple Union Query in Access, but when I refresh the "Source" it doesn't show up (and half the time all the queries disappear for no reason but come back after a dozen of so refreshes). ...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4