Forum Discussion

rifdhyh's avatar
rifdhyh
Regular Visitor
4 years ago
Solved

Getting Values by MAXIMUM Alphabatic Letter for Distinct Records

Hi All, Good day..! May I ask how can I get the values for "For Resubmit" Column by below conditions My Data Table as below     1. Consider only Latest Revision (Lastest Alphbatical L...
Alphabatic
MAXX
Measures to Columns
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi rifdhyh 
    Her eis the sample file with the solution https://we.tl/t-83VSAA2vug

    For Resubmit = 
VAR CurrentRevision =
    RFA[Revision]
VAR CurrentResponse =
    RFA[Engineers Response]
VAR CurrentRFATable = 
    CALCULATETABLE ( RFA, ALLEXCEPT ( RFA, RFA[RFA No] ) )
VAR LatestRevision =
    MAXX ( CurrentRFATable, RFA[Revision] )
RETURN
    IF ( 
        CurrentRevision = LatestRevision 
            && CurrentResponse IN { "Data Incomplete, please resubmit", "Rejected" },
        1
    )
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

rifdhyh 

I don't fully understand the rest of the conditions (I believe you can handle this part) however, for the last revision you can use

Maximum Revision number =
MAXX (
    CALCULATETABLE ( 'RFA', ALLEXCEPT ( 'RFA', 'RFA'[Rfa No] ) ),
    'RFA'[Revision]
)