Forum Discussion
hari_bi
Helper I
Helper IExcel 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
Super User
Super UserHi,
In the abridged file that you have shared with me, what is the fiscal month and what is the reporting month?
hari_biHelper I
Helper IHi 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
Hi,
That link leads to an eroneous page
- hari_bi
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.
Hi All,
Was there ever a solution for this. I have the same problem.
CheersR