Returning Tables From A Single Excel Cube Formula Connected To Power BI
Chris Webb BI
MAY 28, 2023
After my post on tuning Excel cube functions last week there was some (justified) moaning on Twitter about their performance. This got me thinking about other things you could do with cube functions that might improve performance and I had a crazy idea… Late last year two new DAX functions were introduced which didn’t get much attention: ToCSV and ToJSON.