I would like to resolve this issues.
I have a table with columns name’s Table1[Time_Code] and Table1[Fact_Value], the issue is when I try to identify Max Table1[Fact_Value] sometime where are lot of Max value in the same columns, me I wouldlike juste to print Max Table1[Fact_Value] corresponding to latest Table1[Time_Code].
| Time_Code | Fact_Valu |
|---|---|
| 1990 | 22 |
| 1991 | 22 |
| 1992 | 17 |
| 1993 | 4 |
the printing year will be 1991
I try this is but he doesn’t reflect my expected year
My expected value will be 1991 due to Max value and note 1990 or anything
My expected value will be 1991 due to Max value and note 1990 or anything