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...
v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi hari_bi

 

You may try below measure. If it is not your case,  share your file in Dropbox and post the link here.

lookup =
CALCULATE (
    VALUES ( Table2[Months Cover] ),
    FILTER ( ALL ( Table2 ), Table2[Fiscal Month] = Table2[Reporting Month] )
)

 

Regards,

Cherie

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

Hi Cherie

 

Thanks for your replay.

 

https://www.dropbox.com/s/lnvnttc4tvmiq7k/Local%20Copy%20R%26D.pbix?dl=0

 

Please find the Index Match page, my query is available on table visual.

Months Cover will avaialebe in Depletions Table and months cover is a calcualted measure not a base measure.

Fiscal Month (Fiscal Month) available in Date table

Reporting Month available on Forecast Date table.

 

Thank you

Hari.