Unable to convert the Excel Formula into Power BI

Dear all Power BI Experts,   Since Last10 days still I am trying to apply the excel formula into Power BI. But Unable to done it. Kindly help me to get this Done.   Sample File is attached here...