Highlander75
New Member
- Joined
- Sep 18, 2014
- Messages
- 7
Hi
Apologies for maybe not using the right terminology (New to powerpivot), but I would appreciate help with the following:
I have the following scenario example:
Table 1:
Product StartDate End Date
A 1 Jan 30 Jan
B 1 Jan 1 Apr
C 1 Feb 30 Mar
D 1 Mar 1 Apr
Table 2
Date Month
1 Jan Jan
30 Jan Jan
1 Feb Feb
1 Mar Mar
1 Apr Apr
I am trying to get the following pivot table result: (Where I count tx in the month the transaction falls in)
Jan Feb Mar Apr
StartDate 2 1 1 0
EndDate 1 0 1 2
My problem seems to stem from trying to use 2 different date columns?
Any solutions?
Much appreciated
Apologies for maybe not using the right terminology (New to powerpivot), but I would appreciate help with the following:
I have the following scenario example:
Table 1:
Product StartDate End Date
A 1 Jan 30 Jan
B 1 Jan 1 Apr
C 1 Feb 30 Mar
D 1 Mar 1 Apr
Table 2
Date Month
1 Jan Jan
30 Jan Jan
1 Feb Feb
1 Mar Mar
1 Apr Apr
I am trying to get the following pivot table result: (Where I count tx in the month the transaction falls in)
Jan Feb Mar Apr
StartDate 2 1 1 0
EndDate 1 0 1 2
My problem seems to stem from trying to use 2 different date columns?
Any solutions?
Much appreciated
Last edited: