Forum Discussion

Helper 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...

hari_bi

Helper I

8 years ago

Hi Ashish Mathur,

Thanks for your replay.

Please find the below path cleaned "Excel Index Match"PBI file.

https://www.dropbox.com/s/ov3gh5i0jpapshv/Excel%20Index%20Match.pbix?dl=0

Thank you.

Hari.

Ashish_Mathur

Super 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?

hari_bi
Helper I
8 years ago
Hi Ashish Mathur,

https://www.dropbox.com/s/osys6n66euka2y0/Excel%20Index%20Match.pbix?dl=0

Please Consider Year Month column from Date Tabe and [ForecastPublishMonth] as Reporting month from Forecast Date table.
Presently matching data not available.

thaks you.
Hari
- Ashish_Mathur
  Super User
  8 years ago
  Hi,
  
  That link leads to an eroneous page
  - hari_bi
    Helper I
    8 years ago
    Hi Ashish Mathur,
    
    Please try this link , anyone can access this link no restriction on access.
    https://www.dropbox.com/s/osys6n66euka2y0/Excel%20Index%20Match.pbix?dl=0
    
    Thanks,
    Hari.

Forum Discussion

Excel Index match in DAX

Related content

Dax for Excel Index Match

INDEX MATCH in Power BI

Multiple conditions Index

Index match

Index