Sun.May 28, 2023

article thumbnail

Returning Tables From A Single Excel Cube Formula Connected To Power BI

Chris Webb BI

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.

Sales 231