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..?
<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>
</tbody>
Live Price | Target price | Array Formula | Result |
81500 | 83000 | {=INDEX(A3:A5,MATCH(TRUE,A3:$A$5-B2>0,0))} | 83,100 |
82000 | 82500 | "{=INDEX(A4:A6,MATCH(TRUE,A4:$A$5-B3>0,0))} | 82,900 |
82900 | 85000 | "{=INDEX(A5:A7,MATCH(TRUE,A5:$A$5-B4>0,0))} | Not Achieved |
83100 | 86000 | "{=INDEX(A6:A8,MATCH(TRUE,A$5:$A6-B5>0,0))} | Not Achieved |
<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>
</tbody>