Power BI – Excel optimization

For a project I’m doing, I am stuck on a solution which doesn’t seem ideal. The problem is the following: