PowerPivot Index and Match Help!

[rgodfrey]

I have written my formula in excel and now I want to convert this to PowerPivot DAX language. Does anyone have any recommendations on how I would convert the following formula? I'm just trying to pull Actuals over (Formula column) where State,Month and equal and where the Version equals "Actuals".

=INDEX($G$2:$G$13,MATCH(1,(C3=$C$2:$C$13)*(F3=$F$2:$F$13)*("Actuals"=$E$3:$E$13),0),1)

[TABLE="width: 530"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]FORMULA[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Unit[/TD]
[TD="align: center"]State[/TD]
[TD="align: center"]Type[/TD]
[TD="align: center"]Version[/TD]
[TD="align: center"]Month[/TD]
[TD="align: center"]Qty[/TD]
[TD="align: center"]Actuals[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]Tires[/TD]
[TD="align: center"]MA[/TD]
[TD="align: center"]SLS[/TD]
[TD="align: center"]Version1[/TD]
[TD="align: center"]Jan-15[/TD]
[TD="align: center"]16.49[/TD]
[TD="align: center"]16.49[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]Tires[/TD]
[TD="align: center"]MA[/TD]
[TD="align: center"]SLS[/TD]
[TD="align: center"]Actuals[/TD]
[TD="align: center"]Jan-15[/TD]
[TD="align: center"]16.49[/TD]
[TD="align: center"]16.49[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]Tires[/TD]
[TD="align: center"]MA[/TD]
[TD="align: center"]SLS[/TD]
[TD="align: center"]Version2[/TD]
[TD="align: center"]Jan-15[/TD]
[TD="align: center"]16.49[/TD]
[TD="align: center"]16.49[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]Tires[/TD]
[TD="align: center"]MA[/TD]
[TD="align: center"]SLS[/TD]
[TD="align: center"]Version3[/TD]
[TD="align: center"]Jan-15[/TD]
[TD="align: center"]16.49[/TD]
[TD="align: center"]16.49[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"]Tires[/TD]
[TD="align: center"]MA[/TD]
[TD="align: center"]SLS[/TD]
[TD="align: center"]Version4[/TD]
[TD="align: center"]Jan-15[/TD]
[TD="align: center"]16.49[/TD]
[TD="align: center"]16.49[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: center"]Tires[/TD]
[TD="align: center"]MA[/TD]
[TD="align: center"]SLS[/TD]
[TD="align: center"]Version5[/TD]
[TD="align: center"]Jan-15[/TD]
[TD="align: center"]16.49[/TD]
[TD="align: center"]16.49[/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: center"]Tires[/TD]
[TD="align: center"]MA[/TD]
[TD="align: center"]SLS[/TD]
[TD="align: center"]Version4[/TD]
[TD="align: center"]Jan-15[/TD]
[TD="align: center"]16.49[/TD]
[TD="align: center"]16.49[/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD="align: center"]Tires[/TD]
[TD="align: center"]MA[/TD]
[TD="align: center"]SLS[/TD]
[TD="align: center"]Version1[/TD]
[TD="align: center"]Dec-15[/TD]
[TD="align: center"]27.73[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: center"]Tires[/TD]
[TD="align: center"]MA[/TD]
[TD="align: center"]SLS[/TD]
[TD="align: center"]Version1[/TD]
[TD="align: center"]Jan-16[/TD]
[TD="align: center"]17.55[/TD]
[TD="align: center"]17.55[/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD="align: center"]Tires[/TD]
[TD="align: center"]MA[/TD]
[TD="align: center"]SLS[/TD]
[TD="align: center"]Actuals[/TD]
[TD="align: center"]Jan-16[/TD]
[TD="align: center"]34.07[/TD]
[TD="align: center"]17.55[/TD]
[/TR]
[TR]
[TD="align: center"]12[/TD]
[TD="align: center"]Tires[/TD]
[TD="align: center"]MA[/TD]
[TD="align: center"]SLS[/TD]
[TD="align: center"]Version2[/TD]
[TD="align: center"]Jan-16[/TD]
[TD="align: center"]34.07[/TD]
[TD="align: center"]17.55[/TD]
[/TR]
</tbody>[/TABLE]

THANK YOU!