@marcster_uk This is more of an application for others’ benefit than a how-to, but at my company we’ve found DAX Studio crucial for creating snapshots in time of the results of some of our monthly processes. Power BI’s native exporting capabilities are limited in record size, but with DAX Studio we’re able to extract millions of records to compile elsewhere.
For example, we’re able to compare our forecast for Q4 2020 as it existed as of February 2020 to our forecast of Q4 2020 as it exists now in May 2020 (very different ). DAX Studio, just by using the EVALUATE command on the table name from the model, allows us to enshrine our current view of things for posterity. We just append further iterations to that data set over time.