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
<tbody>
</tbody>
I would like to see "USD" also if i could get the last exchange rate received "1.35".
Thanking you in advance.
Steven
TYPE | LOCATION | BRAND | JOURNAL DATE | REFERENCE | NOTE | MODEL | SKU | SIZE | COLR | RETAIL | COST | CURR | EXCH | REBATE | UNIT LANDED COST | EST | UNITS | MKP | EXT LANDED COST |
RG | 0001 | Enti Clothing (MK) | 01/27/17 | 56735 | GAMK - 17098 | GT409 | 1166209 | S/P | WHIT | $95.00 | $37.00 | USD | 1.35 | $39.45 | $ | 8 | 60 % | $ | |
1166210 | M/M | WHIT | $95.00 | $37.00 | USD | 1.35 | $39.45 | $ | 8 | 60 % | $ | ||||||||
1166211 | L/G | WHIT | $95.00 | $37.00 | USD | 1.35 | $39.45 | $ | 4 | 60 % | $ | ||||||||
03/06/17 | 57088 | DEMC -- 17313 | GT409 | 1166209 | S/P | WHIT | $95.00 | $37.00 | USD | 1.35 | $39.45 | $ | 6 | 60 % | $ | ||||
1166210 | M/M | WHIT | $95.00 | $37.00 | USD | 1.35 | $39.45 | $ | 6 | 60 % | $ | ||||||||
1166211 | L/G | WHIT | $95.00 | $37.00 | USD | 1.35 | $39.45 | $ | 3 | 60 % | $ | ||||||||
0001 Total | $ | 35 | 60 % | $ |
<tbody>
</tbody>
Last edited: