Ramesh Deo
Member
Dear Ninjas,
I am new to power pivot, power query and power view. appreciate if any help to deal this below formula into DAX and please suggest any tutorial or guide for power query, power pivot and power view as well.
=INDEX(Sheet2!$D:$D,MATCH(TRUE,IF(Sheet1!A2=Sheet2!A:A,ISNUMBER(SEARCH("store",Sheet2!$C:$C))),0))
Regards
Ramesh Deo
I am new to power pivot, power query and power view. appreciate if any help to deal this below formula into DAX and please suggest any tutorial or guide for power query, power pivot and power view as well.
=INDEX(Sheet2!$D:$D,MATCH(TRUE,IF(Sheet1!A2=Sheet2!A:A,ISNUMBER(SEARCH("store",Sheet2!$C:$C))),0))
Regards
Ramesh Deo