PowerPivot Forum

I don't really understand, but you may find this article I wrote a couple of weeks ago useful - it seems like the principles are similar. You may be able to work it out from there.
https://exceleratorbi.com.au/compound-growth-using-dax/

How do you know this stuff Jes?

Interesting problem. It is hard for me to give you clear advice on this despite the detail you have provided. Power Pivot is great for working over large tables of data. Excel is great for working on bespoke calculations. If you can load data into tables for processing, then Power Pivot it is great,...

What formula would you write to count the number of customers that have sales > 5000 over all time?

= COUNTROWS ( VALUES (Table[Column])) vs = DISTINCTCOUNT (Table[Column]) There is no one right or wrong way. Sometimes one way is better but even then it is often personal preference. My book is designed to teach you reusable concepts, and in this case I was teaching you that you can create virtual...

For the record, I sorted this for fatanalyst. Contact me at my website if you have a similar issue

Very strange. I will be at Microsoft next week. I will add this to the list of things to follow up on (unless someone else knows.

This is not enough Information for anyone to help you.

Maybe you could be a bit more specific?

What version of Excel? Excel 2016 is the most risky (I always keep incremental backups)

Read my article here Power Pivot Crashes
Maybe also try migrating the data model to Power BI as a way of saving it