Looking to find last currency received

[shophoney]

Hi I have a Powerpivot table and I want to create a dax formula to extract the last currency the item was received.

I would like to see "USD" also if i could get the last exchange rate received "1.35".

Thanking you in advance.

Steven

[TABLE="width: 1594"]
<tbody>[TR]
[TD]TYPE[/TD]
[TD]LOCATION[/TD]
[TD]BRAND[/TD]
[TD]JOURNAL DATE[/TD]
[TD]REFERENCE[/TD]
[TD]NOTE[/TD]
[TD]MODEL[/TD]
[TD]SKU[/TD]
[TD]SIZE[/TD]
[TD]COLR[/TD]
[TD]RETAIL[/TD]
[TD]COST[/TD]
[TD]CURR[/TD]
[TD]EXCH[/TD]
[TD]REBATE[/TD]
[TD]UNIT LANDED COST[/TD]
[TD]EST[/TD]
[TD]UNITS[/TD]
[TD]MKP[/TD]
[TD]EXT LANDED COST[/TD]
[/TR]
[TR]
[TD]RG[/TD]
[TD]0001[/TD]
[TD]Enti Clothing (MK)[/TD]
[TD="align: right"]01/27/17[/TD]
[TD]56735[/TD]
[TD]GAMK - 17098[/TD]
[TD]GT409[/TD]
[TD="align: right"]1166209[/TD]
[TD]S/P[/TD]
[TD]WHIT[/TD]
[TD="align: right"]$95.00[/TD]
[TD="align: right"]$37.00[/TD]
[TD]USD[/TD]
[TD="align: right"]1.35[/TD]
[TD][/TD]
[TD="align: right"]$39.45[/TD]
[TD="align: right"]$[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]60 %[/TD]
[TD="align: right"]$[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1166210[/TD]
[TD]M/M[/TD]
[TD]WHIT[/TD]
[TD="align: right"]$95.00[/TD]
[TD="align: right"]$37.00[/TD]
[TD]USD[/TD]
[TD="align: right"]1.35[/TD]
[TD][/TD]
[TD="align: right"]$39.45[/TD]
[TD="align: right"]$[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]60 %[/TD]
[TD="align: right"]$[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1166211[/TD]
[TD]L/G[/TD]
[TD]WHIT[/TD]
[TD="align: right"]$95.00[/TD]
[TD="align: right"]$37.00[/TD]
[TD]USD[/TD]
[TD="align: right"]1.35[/TD]
[TD][/TD]
[TD="align: right"]$39.45[/TD]
[TD="align: right"]$[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]60 %[/TD]
[TD="align: right"]$[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]03/06/17[/TD]
[TD]57088[/TD]
[TD]DEMC -- 17313[/TD]
[TD]GT409[/TD]
[TD="align: right"]1166209[/TD]
[TD]S/P[/TD]
[TD]WHIT[/TD]
[TD="align: right"]$95.00[/TD]
[TD="align: right"]$37.00[/TD]
[TD]USD[/TD]
[TD="align: right"]1.35[/TD]
[TD][/TD]
[TD="align: right"]$39.45[/TD]
[TD="align: right"]$[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]60 %[/TD]
[TD="align: right"]$[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1166210[/TD]
[TD]M/M[/TD]
[TD]WHIT[/TD]
[TD="align: right"]$95.00[/TD]
[TD="align: right"]$37.00[/TD]
[TD]USD[/TD]
[TD="align: right"]1.35[/TD]
[TD][/TD]
[TD="align: right"]$39.45[/TD]
[TD="align: right"]$[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]60 %[/TD]
[TD="align: right"]$[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1166211[/TD]
[TD]L/G[/TD]
[TD]WHIT[/TD]
[TD="align: right"]$95.00[/TD]
[TD="align: right"]$37.00[/TD]
[TD]USD[/TD]
[TD="align: right"]1.35[/TD]
[TD][/TD]
[TD="align: right"]$39.45[/TD]
[TD="align: right"]$[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]60 %[/TD]
[TD="align: right"]$[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]0001 Total[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]$[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]60 %[/TD]
[TD="align: right"]$[/TD]
[/TR]
</tbody>[/TABLE]