Dax Query for Table Visual

[jayasurya_prud]

Hi!

I am creating a DAX Query for mutiple operations like we do by cell refrencing in Excel. My table is 

Prev Year	Rate	Y1	Y2	Y3	Y4	Y5	Y6	G1	G2	G3	G4	G5	G6	A1	A2	A3	A4	A5	A6
83	0.55							0	0	0.013830532	0.352490663	0.18745098		0.004612212	0.048784417	0.097376666	0.0475	0.113431373
		45
		45	44
		65	65	60
		56	56	51	45
		54	53	53	46	20
		50	50	45	45	20	19
		26	26	26	22	18	11

From this table, my first calc is Y1 Col - 1st cell value (Which is a missing) should be Prev Year * Rate = Which gives 45.65 - after rounding 46

2nd Calculation is, Y2 1st cell should be - 45 (Y1 2nd Cell) * (1-(G1 - A1)))

3rdCalculation is, Y3 1st cell should be - 44 (Y2 3rd Cell) * (1-(G2 - A2)))

4th  Calculation is, Y4 1st cell should be - 60 (Y3 4th Cell) * (1-(G3 - A3)))

5th Calculation is, Y5 1st cell should be - 45 (Y4 5th Cell) * (1-(G4 - A4)))

6th Calculation is, Y6 1st cell should be - 20 (Y5 6th Cell) * (1-(G5 - A5)))

At last, I should be showing only the 1st row with the results of y1 - y6 calculations and its total. 

I need to make sure that I should be able to slice the data by rates, Prev Year and G1-G6 and A1-A6 in What if parameters.