I would then put the data in the power pivot data model (or Fabric Semantic Model) and do CUBEVALUE formula on it. Here is a good link on CUBE functions: https://dataempower.net/excel/excel-cube-functions-explained-cubevalue-cubeset-cubemember/