Here is the sample data with formula which works fine in excel... But i want to get this results in DAX than what are the suggested functions to be used..?
[TABLE="width: 742"]
<colgroup><col width="76" style="width:57pt"> <col width="158" style="width:119pt"> <col width="403" style="width:302pt"> <col width="105" style="width:79pt"> </colgroup><tbody>[TR]
[TD="class: xl111, width: 76"]Live Price[/TD]
[TD="class: xl111, width: 158"]Target price[/TD]
[TD="class: xl111, width: 403"]Array Formula[/TD]
[TD="class: xl111, width: 105"]Result[/TD]
[/TR]
[TR]
[TD="class: xl120"]81500[/TD]
[TD="class: xl116"]83000[/TD]
[TD="class: xl112"]{=INDEX(A3:A5,MATCH(TRUE,A3:$A$5-B2>0,0))}[/TD]
[TD="class: xl112, align: right"] 83,100 [/TD]
[/TR]
[TR]
[TD="class: xl121"]82000[/TD]
[TD="class: xl117"]82500[/TD]
[TD="class: xl113"]"{=INDEX(A4:A6,MATCH(TRUE,A4:$A$5-B3>0,0))}[/TD]
[TD="class: xl113, align: right"] 82,900 [/TD]
[/TR]
[TR]
[TD="class: xl120"]82900[/TD]
[TD="class: xl116"]85000[/TD]
[TD="class: xl112"]"{=INDEX(A5:A7,MATCH(TRUE,A5:$A$5-B4>0,0))}[/TD]
[TD="class: xl112"]Not Achieved [/TD]
[/TR]
[TR]
[TD="class: xl121"]83100[/TD]
[TD="class: xl117"]86000[/TD]
[TD="class: xl113"]"{=INDEX(A6:A8,MATCH(TRUE,A$5:$A6-B5>0,0))}[/TD]
[TD="class: xl113"]Not Achieved [/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 742"]
<colgroup><col width="76" style="width:57pt"> <col width="158" style="width:119pt"> <col width="403" style="width:302pt"> <col width="105" style="width:79pt"> </colgroup><tbody>[TR]
[TD="class: xl111, width: 76"]Live Price[/TD]
[TD="class: xl111, width: 158"]Target price[/TD]
[TD="class: xl111, width: 403"]Array Formula[/TD]
[TD="class: xl111, width: 105"]Result[/TD]
[/TR]
[TR]
[TD="class: xl120"]81500[/TD]
[TD="class: xl116"]83000[/TD]
[TD="class: xl112"]{=INDEX(A3:A5,MATCH(TRUE,A3:$A$5-B2>0,0))}[/TD]
[TD="class: xl112, align: right"] 83,100 [/TD]
[/TR]
[TR]
[TD="class: xl121"]82000[/TD]
[TD="class: xl117"]82500[/TD]
[TD="class: xl113"]"{=INDEX(A4:A6,MATCH(TRUE,A4:$A$5-B3>0,0))}[/TD]
[TD="class: xl113, align: right"] 82,900 [/TD]
[/TR]
[TR]
[TD="class: xl120"]82900[/TD]
[TD="class: xl116"]85000[/TD]
[TD="class: xl112"]"{=INDEX(A5:A7,MATCH(TRUE,A5:$A$5-B4>0,0))}[/TD]
[TD="class: xl112"]Not Achieved [/TD]
[/TR]
[TR]
[TD="class: xl121"]83100[/TD]
[TD="class: xl117"]86000[/TD]
[TD="class: xl113"]"{=INDEX(A6:A8,MATCH(TRUE,A$5:$A6-B5>0,0))}[/TD]
[TD="class: xl113"]Not Achieved [/TD]
[/TR]
</tbody>[/TABLE]