Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    4
    Views
    679

    Re: Row Total Incorrect Using SumX

    I ended up creating a measure for each month, then a measure that added all the months together.
  2. Replies
    4
    Views
    679

    Re: Row Total Incorrect Using SumX

    <tbody>

    A
    B
    C
    D
    E
    F
    G
  3. Replies
    4
    Views
    679

    Row Total Incorrect Using SumX

    I have a simple table and am using sumx, but the row total is incorrect.

    The measure is: =sumx(daily,[Gallons]*[NACVal]/[Acres])/[rows]

    The output looks like this:

    <colgroup><col><col...
  4. Thread: DAX Average

    by JNM
    Replies
    3
    Views
    620

    Re: DAX Average

    And the result is 183, not 165 - fat fingered the calculator...
  5. Thread: DAX Average

    by JNM
    Replies
    3
    Views
    620

    Re: DAX Average

    Got it!


    =Averagex(VALUES('Date Value'[FYrTxt]),[TTl SalesQty])
  6. Thread: DAX Average

    by JNM
    Replies
    3
    Views
    620

    Re: DAX Average

    It didn't upload my picture so here it is in a layout

    Item Year1 Year2 Year3 Year4 Year5 TtlYr AvgYr
    AB0 460 232 122 92 9 915 10
  7. Thread: DAX Average

    by JNM
    Replies
    3
    Views
    620

    DAX Average

    I need some help on how to create a measure that does the average of 5 year columns shown. Each of the columns are separate measures. As shown in the picture the AverageTtlSales value isn't the...
  8. Replies
    1
    Views
    365

    Re: Show Only Items Short

    The separate table idea worked. Added a measure calculate filtered to 1s (items short), then added a "related" column to the saleslines tables with the values short, measure summing those and...
  9. Replies
    1
    Views
    365

    Show Only Items Short

    Fact table - Sales Lines, linked to lookup Item table with Quantity on Hand (QOH) value in column b. Pivottable shows all sales lines grouped by order. Item A is in Order 1 with a quantity of 5,...
  10. Replies
    0
    Views
    305

    Show only rows with values

    I have a powerpivot table set up and would like to show only rows the QtyShort measure has a value. I tried
    =if(QtyShort<>0,qtySlslnLessPkgLn,QtySlsLnLesPkgLn-QtySlsLnLessPkgLn) but all it does is...
  11. Replies
    4
    Views
    954

    Re: Multiple Relationship between same Tables

    Let's assume Manager table 1 has two columns - Manager code and Manager name, there are six rows to this table and it's on Sheet 1 starting at A2. Add a second Manager table starting at D2, down six...
  12. Replies
    4
    Views
    954

    Re: Multiple Relationship between same Tables

    I have done something similar with a SQL backend... If you go to the table you want to duplicate, then select Table Design/Table properties and switch to "Query Editor". Copy the resulting code and...
  13. Replies
    3
    Views
    389

    Re: Measure Not Recalcuating on Refresh

    Hmm - sounds like we have found a bug!
  14. Replies
    3
    Views
    389

    Measure Not Recalcuating on Refresh

    Good afternoon,

    I have a PowerPivot workbook that is pulling info from an SQL view. I can refresh the table, but the measure at the bottom is not recalculating with the refreshed data. There...
  15. Replies
    2
    Views
    626

    How to Capture Highlighted Slicer Results

    I am able to capture slicer results using cubeset, but it only works if an item in the slicer is actually selected. Is there a way to capture the results of a slicer when it's not selected, but is...
  16. Replies
    2
    Views
    504

    Re: PowerPivot Basic Help Needed

    Thanks for the suggestion - I did try that, but it didn't work as I needed it to either. But, I do have it working!
    I created two related columns in the SlsLn table - one for Pkg and one for Inv....
  17. Replies
    2
    Views
    504

    PowerPivot Basic Help Needed

    Hi - am learning PowerPivot on Excel 2013 and need a little help. I have brought in three tables - Saleslines is the Fact Table, two columns SLItemNo and SLQty. The lookup tables are Inventory...
  18. Replies
    1
    Views
    2,846

    Re: DAX - How to Sum Time in Minutes

    Found the answer here:

    Q: How can I calculate difference between two dates in DAX (seconds, minutes, hours, days and months)
  19. Replies
    1
    Views
    2,846

    DAX - How to Sum Time in Minutes

    I have a linked Excel spreadsheet that has a start and end time, these times never split a day - earliest start is 7:00 am and end is 4:30 pm or earlier. I have created a calculated column titled...
  20. Replies
    1
    Views
    499

    Enter Custom Function when Cell Value Changes

    Hello,

    I have shared workbook that employees are entering job info -start date, start time, end date, end time, etc. I've now created custom function to total the time.


    Function...
  21. Replies
    2
    Views
    632

    Re: VBA Autofilter Not Working with Date

    Dave,

    Thank you for the revised code. It worked perfectly!!
    JNM
  22. Replies
    2
    Views
    632

    VBA Autofilter Not Working with Date

    Good afternoon,

    I am getting error 1004 "AutoFilter method of Range class failed" when opening a workbook. I would like the workbook to autofilter the Start Date to those dates from the past two...
  23. Re: Using non-calendar date ranges for cumulative functions

    I'm looking for a similar fix. Our "for example" - start date 10/1/2010, end date 9/30/2013. Group by Year starting with start date and show three headers as follows - 10/1/2010..9/30/2011,...
  24. Replies
    4
    Views
    7,017

    Re: PowerPivot Load on Startup Anomolies

    Thanks Jerry,

    I do use macros and personal.xlsb was there. Moved it to my desktop. Tested and PP stayed.

    I need my macros :) I do have buttons set up to run the macros but, of course, by...
  25. Replies
    4
    Views
    7,017

    PowerPivot Load on Startup Anomolies

    Hello all,

    I've made some observations on how PP loads and am wondering if others are seeing the same issue. We are using Excel 2010. PP does not always load on startup for some of our users. ...
Results 1 to 25 of 35
Page 1 of 2 1 2