sorry for the delay in replying. I go tied up on another project. This is a formula I use in ACCESS. AM I able to do something similar in PowerBI?
PSC Ticket: IIf([LU Company]="YES G",IIf([PXFR NTG]![JobTypeName]="Transfer",IIf([PXFR NTG]![NextToGoStartDate]>=#09/30/2024#,"YES"),"High Priority")