Search:

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

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Replies
    2
    Views
    360

    Re: Power Pivot Table fields not refreshing

    UPDATE.

    I had to create/insert a new worksheet and create the pivot table again to access the measure I needed.

    When I worked from a copy of a worksheet with an existing pivot table linked...
  2. Replies
    2
    Views
    360

    Power Pivot Table fields not refreshing

    Is there a finite number of measures that can be created in Powerpivot?
    I have numerous measures; after refreshing all; some measures disappear from the table fields.
    I've tried searching by...
  3. Replies
    0
    Views
    270

    Dax Measures and PivotTable Options

    My pivot tables have lots of 0.00 values.

    PivotTable Option formatting only allow one substitution: For empty cell values show: --

    Is there an option to include another substitution: For...
  4. Replies
    5
    Views
    578

    Re: cleaning up data in PowerQuery

    The pattern I want keep is any value that is a combination of 2 letters followed by 4 numbers, ie. AA1234.
  5. Replies
    5
    Views
    578

    cleaning up data in PowerQuery

    I have a column in PQ that needs cleaning up. I'ld like to keep values that end with a combination of 1-letter and 4-digits.

    Keep this pattern: ...A1234

    Filter out this value pattern: ...
  6. Replies
    4
    Views
    1,059

    Re: Lost Data Model in Excel 2016

    Ok...so it has to do with multiple Microsoft Mashup Evaluation Container running in Win10; up to 7 instances when I have closed the Excel file(s). I closed these container files via Task Manager....
  7. Replies
    4
    Views
    1,059

    Re: Lost Data Model in Excel 2016

    Hi Jerry,

    The first place I checked was Tools -->Options---> Add-ins ---> COM Add-Ins

    The Powerpivot box is checked to load on Start up

    When I right-click on Customize Ribbon, I don't have a...
  8. Replies
    4
    Views
    1,059

    Lost Data Model in Excel 2016

    Powerpivot disappeared from the ribbon. Is there a quick fix or should I abandon my current file and go forward with the backup copy?
  9. Re: PowerQuery - Filter to only earliest record

    Hi Dave,

    If you're still looking for a solution...I had posted similar scenario and ParamRay replied with the code to an excellent solution for me.

    Check out:...
  10. Replies
    6
    Views
    1,155

    Re: Forecasting in Power Query or Powerpivot?

    Hi bkjohn2016, wow...that's amazing :eeek: I'm going to try to recreate your results in Excel 2016. I've also noted macfuller's input. I'm constantly learning; this model will required a bit more...
  11. Replies
    6
    Views
    1,155

    Forecasting in Power Query or Powerpivot?

    I would like to forecast the values for each X variable for each Group. There is 5 years worth of data for Groups A-D, Group E has 2 years worth of data. Regardless, I would like to forecast values...
  12. Re: Best mobile workstation to run Excel 2016 PowerQuery and Powerpivot?

    The PC is perfect, but I need a laptop. I haven't worked on a laptop in a long time. Looking at the Dell XPS 15 or Lattitude 15.6 and wondering how these rate.
  13. Best mobile workstation to run Excel 2016 PowerQuery and Powerpivot?

    Seeking laptop recommendations. Iím currently on an XPS27 AIO which is a 64-bit operating system, Intel(R) Core(TM) i7-4770S CPU @ 3.10 GHz with 16.0 GB installed RAM.
  14. Re: Power Query 2016: return the latest date in a subset

    Excellent! Thanks for providing the code. :)
  15. Power Query 2016: return the latest date in a subset

    I have tracking data that contains many dates for the same person. How can records be cleaned up so that it shows only the latest date for each person. Here is an example of the data:


    <tbody>...
  16. Replies
    4
    Views
    2,601

    Re: PowerQuery Rounding

    Excellent! I wasn't sure if I had written it correctly. I was getting errors...it was the data type that was throwing Custom3 off. Thank you.
  17. Replies
    4
    Views
    2,601

    Re: PowerQuery Rounding

    Hi Owen,

    Thanks for the response. I did use the Round Up function on the ribbon...but was wondering how to write the RoundUp within another formula. For example, I have two custom columns and...
  18. Replies
    4
    Views
    2,601

    PowerQuery Rounding

    How would you round the number 2.33 up to whole number 3 instead of the 2. Power Query's default for 0.33 is to round down and I want to round up.

    Also, how would you wrap the ROUND function in a...
  19. Replies
    1
    Views
    226

    Re: PowerQuery Merging multiple queries

    UPDATE SOLVED. I cleaned up the text in the common columns using TRIM function and that seem to do the trick.
  20. Replies
    1
    Views
    226

    PowerQuery Merging multiple queries

    I would like to add 2 new columns to the Main query by merging from each Rate table. The values in the expanded column do not populate down the rows, across all data files (only the rows of 1 data...
  21. Re: Subtotal for Calculated Column in Power Pivot Table

    Unless you need the 1,0 flags, I would forgo these in the formula. Here's what I got. The table is named 'Range'. TargetMet2 is a calculated column, while TargetMet and TargetMet FIXED are...
  22. Replies
    4
    Views
    463

    Re: PowerPivot Filtering DAX Formula

    This should work....

    Invoice <500 FIXED:=IF([Sum of Revenue]<500,[Sum of Revenue],SUMX(DISTINCT(Range[Invoice]),[Invoice <500]))
  23. Replies
    4
    Views
    463

    Re: PowerPivot Filtering DAX Formula

    Invoice <500:=IF([Sum of Revenue]<500,[Sum of Revenue])
  24. Re: Power Query: Age from Birthdate on Action date

    Is it possible to adjust this custom column formula below to prevent error value on refresh when there is no value to calculate from in the [Birthdate] column?

    =Date.Year([Appl Dt]) -...
  25. Re: Use Power Query to change one column based on criteria in two columns.

    In Power Query add a new Custom Column. The Custom column formula:

    if [Customer Name] = "Acme Corp" and [Location] = "Cleveland" then "Jones Corp" else [Customer Name]
Results 1 to 25 of 49
Page 1 of 2 1 2