Forum Discussion

hari_bi's avatar
hari_bi
Icon for Helper I rankHelper I
8 years ago

Excel Index match in DAX

Excel Formula for above one : =INDEX($AM$9:$AM$20,MATCH(D15,$E$9:$E$20,0))   Now i need to implement the same in DAX Calculated Measure. First i need to get month from "ReportingMoth" cloumn...
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

I would like to help but am unable to because of the confusion caused by so many other Tables in your file.  Just share only as much information as is necessary to solve the problem.  Remove the unwanted Tables/relationships and only share the tables which are required for solving the problem.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    In the abridged file that you have shared with me, what is the fiscal month and what is the reporting month?