BrandNewindian
New Member
- Joined
- Mar 3, 2016
- Messages
- 1
Hi,
All
Help me in this.
=CALCULATE(VALUES(Expedite[Expedite Status ID]),FILTER(ALL('Expedite'),[Epart_key]=EARLIER('Expedite'[Epart_key]) && [Short Key]=MAX('Expedite'[Short Key]) ))
Sample data
[TABLE="width: 231"]
<colgroup><col width="133" style="width: 100pt;"><col width="98" style="width: 74pt;"></colgroup><tbody style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit; margin: 0px; outline: 0px; padding: 0px;">[TR]
[TD="width: 133"]Short key[/TD]
[TD="width: 98"]Epart key[/TD]
[/TR]
[TR]
[TD="width: 133"]20150707150750[/TD]
[TD="width: 98"]1439NM1[/TD]
[/TR]
[TR]
[TD="width: 133"]20150707150750[/TD]
[TD="width: 98"]1439NM1[/TD]
[/TR]
[TR]
[TD="width: 133"]20150707154321[/TD]
[TD="width: 98"]1439NM1[/TD]
[/TR]
[TR]
[TD="width: 133"]20150709165034[/TD]
[TD="width: 98"]1439NM1[/TD]
[/TR]
[TR]
[TD="width: 133"]20150709171747[/TD]
[TD="width: 98"]1439NM1[/TD]
[/TR]
[TR]
[TD="width: 133"]20150731130804[/TD]
[TD="width: 98"]1439NM1[/TD]
[/TR]
[TR]
[TD="width: 133"]20150731140210[/TD]
[TD="width: 98"]1439NM1[/TD]
[/TR]
[TR]
[TD="width: 133"]20150731140210[/TD]
[TD="width: 98"]1439NM1[/TD]
[/TR]
[TR]
[TD="width: 133"]20150731161122[/TD]
[TD="width: 98"]1439OR1[/TD]
[/TR]
[TR]
[TD="width: 133"]20150731161122[/TD]
[TD="width: 98"]1439OR1[/TD]
[/TR]
[TR]
[TD="width: 133"]20150607212946[/TD]
[TD="width: 98"]1439OR1[/TD]
[/TR]
</tbody>[/TABLE]
I am getting an error (Title). where i am wrong.
Thanks in adv.
All
Help me in this.
=CALCULATE(VALUES(Expedite[Expedite Status ID]),FILTER(ALL('Expedite'),[Epart_key]=EARLIER('Expedite'[Epart_key]) && [Short Key]=MAX('Expedite'[Short Key]) ))
Sample data
[TABLE="width: 231"]
<colgroup><col width="133" style="width: 100pt;"><col width="98" style="width: 74pt;"></colgroup><tbody style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit; margin: 0px; outline: 0px; padding: 0px;">[TR]
[TD="width: 133"]Short key[/TD]
[TD="width: 98"]Epart key[/TD]
[/TR]
[TR]
[TD="width: 133"]20150707150750[/TD]
[TD="width: 98"]1439NM1[/TD]
[/TR]
[TR]
[TD="width: 133"]20150707150750[/TD]
[TD="width: 98"]1439NM1[/TD]
[/TR]
[TR]
[TD="width: 133"]20150707154321[/TD]
[TD="width: 98"]1439NM1[/TD]
[/TR]
[TR]
[TD="width: 133"]20150709165034[/TD]
[TD="width: 98"]1439NM1[/TD]
[/TR]
[TR]
[TD="width: 133"]20150709171747[/TD]
[TD="width: 98"]1439NM1[/TD]
[/TR]
[TR]
[TD="width: 133"]20150731130804[/TD]
[TD="width: 98"]1439NM1[/TD]
[/TR]
[TR]
[TD="width: 133"]20150731140210[/TD]
[TD="width: 98"]1439NM1[/TD]
[/TR]
[TR]
[TD="width: 133"]20150731140210[/TD]
[TD="width: 98"]1439NM1[/TD]
[/TR]
[TR]
[TD="width: 133"]20150731161122[/TD]
[TD="width: 98"]1439OR1[/TD]
[/TR]
[TR]
[TD="width: 133"]20150731161122[/TD]
[TD="width: 98"]1439OR1[/TD]
[/TR]
[TR]
[TD="width: 133"]20150607212946[/TD]
[TD="width: 98"]1439OR1[/TD]
[/TR]
</tbody>[/TABLE]
I am getting an error (Title). where i am wrong.
Thanks in adv.