Excel: DAX Earlier function

Hi, I am struggling with DAX EARLIER function in order to populate the FX column with a formula than in excel would be straight forward: formula in cell D2 =IF(C2="X";C2;IF(B2=B1;D1;"")) The row in column FX should be populated with column 3 value if existing, otherwise with the the previous row of FX, this by column 2 groups and Date ascending. Date 2 3 FX 1.Jan A X X 2.Jan AX 3.Jan A X 1.Jan B 2.Jan B X X 3.Jan B X 4.Jan B X 4.Jan C 5.Jan C 6.Jan C X X 7.Jan C X 8.Jan C X Could you please help me? Many thanks in advance, Est Gas.

This question generated 10 answers. To proceed to the answers, click here.

This thread is current as of June 26, 2015.

For more resources for Microsoft Excel