I want to make use of the MAKEARRAY and LAMBDA functions in Excel to help avoid repeating a number of CUBEVALUE/CUBEMEMBER formulas.
This was inspired by Chris Webb's blogpost here: https://blog.crossjoin.co.uk/2021/08/01/excel-cube-functions-dynamic-arrays-and-lambdas-part-2-returning-tables/
Where Chris combined MAKEARRAY / LET / LAMBDA to make a dynamic array to get data from a data model.
I tried to do something similar with my example but can't figure out a way to make it work. I've uploaded the example excel file here:
https://github.com/aeorxc/excelcubelambda/blob/main/heathrowdata.xlsx?raw=true
The table I'm attempting to create is highlighted in blue:
How can I use MAKEARRAY / LET / LAMBDA to create a dynamic table like the above?
