Forum Discussion
Help with a measure
Hello here is my problem, i am trying to return a particular code through a measure from the table below. at the moment code below doesn't contains "Issue Purpose" in it so it returns first val...
hopefully table below will help, based on the EWP and Issue purpose i want to return Milstone code from the Milestones codes table
Milestones Code Table
| Code Value | Description | Index |
| IFC | Issued For Construction | 9 |
| IFR | Issued For Review | 15 |
Forecast Table
| EWP | Issue Purpose | SEPARABLE_PORTION | Forecast_Date | ITR_Name | Max rank | Milestone Codes |
| S-XXX | IFR | Phase 2 | 08-Aug-19 | S-201-IFR | 2 | 15 |
| S-XXX | IFC | Phase 2 | 08-Aug-19 | S-201-IFC | 2 | 9 |
| S-YYY | IFR | Phase 2 | 15-Aug-19 | S-202-IFR | 2 | 15 |
| S-YYY | IFC | Phase 2 | 15-Aug-19 | S-202-IFC | 2 | 9 |
| S-ZZZ | IFR | Phase 2 | 22-Aug-19 | S-203-IFR | 2 | 15 |
| S-ZZZ | IFC | Phase 2 | 22-Aug-19 | S-203-IFC | 2 | 9 |
I am having problems with determining which EWP and Issue purpose is currently active and how to read the value and return a code based on it. Cant think of any particular solution for this.