https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-Implement-Index-and-match-with-array-formulas-in-power-BI/m-p/1043047#M14013 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="313" data-lia-user-login="Greg_Deckler" class="lia-mention lia-mention-user">Greg_Deckler</a> I got your point that it is not possible in PowerBi, but can you please suggest any workaround.</P><P><img /></P> Thu, 23 Apr 2020 03:26:07 GMT tanweer_kashyap 2020-04-23T03:26:07Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-Implement-Index-and-match-with-array-formulas-in-power-BI/m-p/1041729#M13967 <DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV> Wed, 22 Apr 2020 11:40:57 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-Implement-Index-and-match-with-array-formulas-in-power-BI/m-p/1041729#M13967 tanweer_kashyap 2020-04-22T11:40:57Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-Implement-Index-and-match-with-array-formulas-in-power-BI/m-p/1041924#M13979 That DAX function for that is MAGIC() Wed, 22 Apr 2020 13:25:41 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-Implement-Index-and-match-with-array-formulas-in-power-BI/m-p/1041924#M13979 Greg_Deckler 2020-04-22T13:25:41Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-Implement-Index-and-match-with-array-formulas-in-power-BI/m-p/1043047#M14013 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="313" data-lia-user-login="Greg_Deckler" class="lia-mention lia-mention-user">Greg_Deckler</a> I got your point that it is not possible in PowerBi, but can you please suggest any workaround.</P><P><img /></P> Thu, 23 Apr 2020 03:26:07 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-Implement-Index-and-match-with-array-formulas-in-power-BI/m-p/1043047#M14013 tanweer_kashyap 2020-04-23T03:26:07Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-Implement-Index-and-match-with-array-formulas-in-power-BI/m-p/1044335#M14051 No, the point of my post is that there was no information to go on! <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span><BR /><BR />So, with more information, I believe what you want is something along the lines of this: <A href="https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/td-p/985814" target="_blank">https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/td-p/985814</A> Thu, 23 Apr 2020 12:58:45 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-Implement-Index-and-match-with-array-formulas-in-power-BI/m-p/1044335#M14051 Greg_Deckler 2020-04-23T12:58:45Z