index and Match Function in Power BI

[dobracik]

Hello,



Could you please support and Please refer to below snapshot and syntax of Y3 cell from Excel File, i am looking for equivalent DAX syntax to get similar output in Power BI.


IFERROR(INDEX($B$3:$E$20,MATCH(1,($A$3:$A$20=$H3)*($F$3:$F$20=I$1),0),MATCH(I$2,$B$2:$E$2,0)),""

Or how to replicate the above function in Dax if I want to add it into red cell?

Thank you so much ?

 

[Matt Allington]

I don’t even know where to start. Excel is not Power BI. The way you are used to doing it no longer applies If you are using Power BI. Excel is a spreadsheet, power BI is a database. I recommend you start with some structured learning and put your work to one side. You can use my book, but there are of course there are other resources out there too. Read my book reviews at Amazon and see if it is right for you.