Spilling cube function

Copper 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.