why first 3 days returns 2 instead of 1

X

XLBob

Board Regular
Joined
Aug 17, 2012
Messages
65
I have attached a screenshot. the formula for the calculated field is above the pivot table. Can someone tell me why this formula returns 2 for the first 3 days of Mar 2009? The data model sitting behind is simple, just one date table with dates from 1 Jan 09 to 31 Jan 11
~
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

P
  • Question
DAX PIVOT: Projects Closure Date Field - Number of Days Change - between differing Forecast Versions
Replies
0
Views
134
phil134
P
D
  • Question
Power Pivot - Sum Issue
Replies
2
Views
255
d0hb0y
D
J
  • Question
Power Query - Change column to row if columns match - Grouping
Replies
2
Views
343
Jessica553
J
S
  • Solved
Pivot data returning earliest date and latest date (only) counts by a training class number
2
Replies
14
Views
574
SerenityNetworks
S
A
  • Question
Power pivot issue - invalid numeric representation of a date was encountered
Replies
0
Views
864
AuroraBorealis13
A

Forum statistics

Threads
1,215,449
Messages
6,124,911
Members
449,195
Latest member
Stevenciu

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top