Spilling cube function

%3CLINGO-SUB%20id%3D%22lingo-sub-2292644%22%20slang%3D%22en-US%22%3ESpilling%20cube%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2292644%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20day%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20looking%20for%20a%20spill%20(dynamic%20array)%20function%20which%20uses%20data%20from%20the%20Power%20Pivot%20data%20model.%3C%2FP%3E%3CP%3ECurrently%20I'm%20trying%20to%20do%20this%20with%20cube%20functions%2C%20but%20I%20can't%20get%20it%20to%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENormally%20Power%20pivot%20tables%20automaticly%20'spill'%20once%20data%20is%20added%20%26amp%3B%20refreshed.%20I%20would%20like%20to%20do%20this%20without%20the%20limitations%20of%20a%20pivot%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20have%20a%20suggestion%20how%20to%20handle%20this%3F%3C%2FP%3E%3CP%3EThanks%20a%20lot!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2292644%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2292962%22%20slang%3D%22en-US%22%3ERe%3A%20Spilling%20cube%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2292962%22%20slang%3D%22en-US%22%3E%3CP%3EJust%20%3CA%20href%3D%22https%3A%2F%2Fblog.crossjoin.co.uk%2F2019%2F11%2F10%2Fexcel-dynamic-arrays-and-the-cubeset-function%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Eread%20this%20article%3C%2FA%3E.%20Seems%20like%20it%20was%20not%20possible%20in%202019.%3C%2FP%3E%3CP%3EHope%202%20years%20has%20proven%20otherwise.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Good day,

 

I'm looking for a spill (dynamic array) function which uses data from the Power Pivot data model.

Currently I'm trying to do this with cube functions, but I can't get it to work.

 

Normally Power pivot tables automaticly 'spill' once data is added & refreshed. I would like to do this without the limitations of a pivot table.

 

Does anyone have a suggestion how to handle this?

Thanks a lot! 

1 Reply

Just read this article. Seems like it was not possible in 2019.

Hope 2 years has proven otherwise.