# Search:

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

Page 1 of 2 1

1. ## Thread: Row Total Incorrect Using SumX

by JNM
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.

by JNM
Replies
4
Views
679

<tbody>

A
B
C
D
E
F
G
3. ## Thread: Row Total Incorrect Using SumX

by JNM
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...

by JNM
Replies
3
Views
620

### Re: DAX Average

And the result is 183, not 165 - fat fingered the calculator...

by JNM
Replies
3
Views
620

### Re: DAX Average

Got it!

=Averagex(VALUES('Date Value'[FYrTxt]),[TTl SalesQty])

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

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. ## Thread: Show Only Items Short

by JNM
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. ## Thread: Show Only Items Short

by JNM
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. ## Thread: Show only rows with values

by JNM
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. ## Thread: Multiple Relationship between same Tables

by JNM
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. ## Thread: Multiple Relationship between same Tables

by JNM
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. ## Thread: Measure Not Recalcuating on Refresh

by JNM
Replies
3
Views
389

### Re: Measure Not Recalcuating on Refresh

Hmm - sounds like we have found a bug!
14. ## Thread: Measure Not Recalcuating on Refresh

by JNM
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. ## Thread: How to Capture Highlighted Slicer Results

by JNM
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. ## Thread: PowerPivot Basic Help Needed

by JNM
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. ## Thread: PowerPivot Basic Help Needed

by JNM
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. ## Thread: DAX - How to Sum Time in Minutes

by JNM
Replies
1
Views
2,846

### Re: DAX - How to Sum Time in Minutes

Q: How can I calculate difference between two dates in DAX (seconds, minutes, hours, days and months)
19. ## Thread: DAX - How to Sum Time in Minutes

by JNM
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. ## Thread: Enter Custom Function when Cell Value Changes

by JNM
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. ## Thread: VBA Autofilter Not Working with Date

by JNM
Replies
2
Views
632

### Re: VBA Autofilter Not Working with Date

Dave,

Thank you for the revised code. It worked perfectly!!
JNM
22. ## Thread: VBA Autofilter Not Working with Date

by JNM
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. ## Thread: Using non-calendar date ranges for cumulative functions

by JNM
Replies
2
Views
890

### 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,...

by JNM
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...

by JNM
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