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 Letter) for each RFA No. 2. If Engineer Response of those records are "Data Incomplete" or "Rejected" then need to count as 1 in "For Resubmit" Column As per above table I can get values for these records only> Noted: I have used below DAX Function to get Maximum Revision number = UNICHAR(MAXX(DISTINCT('RFA'[Rfa No]),MAX(UNICODE('RFA'[Revision]))) I need to find how can I apply Specific Values in "Engineer response" column to find "Resubmit" Values Thanks in Advance Rifdhy
