Forum Discussion

murillocosta's avatar
murillocosta
Helper I
3 years ago
Solved

calculated column

Hi,   Could someone help me achieve the below.   I have a table which I need to find the max period_id per per facility_id like the example below 425 to facility 1 and 424 to facility 4.   Once...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi murillocosta 

    please try

    NewColumn =
    MAXX (
    TOPN (
    1,
    CALCULATETABLE ( Table01, ALLEXCEPT ( Table01, Table01[FACILITY_ID] ) ),
    Table01[PERIOD_ID]
    ),
    Table01[EXCHANGE_RATE]
    )

tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi murillocosta 

please try

NewColumn =
MAXX (
TOPN (
1,
CALCULATETABLE ( Table01, ALLEXCEPT ( Table01, Table01[FACILITY_ID] ) ),
Table01[PERIOD_ID]
),
Table01[EXCHANGE_RATE]
)