Forum Discussion
Circular Dependency preventing second calculated column creation
I've never seen measures used in this way before. I don't recommend it.
So I think you should replace the usage of the measures in each column with the appropriate DAX - not too complicated to do.
The DAX is a little long-winded but it looks like it will work.
--------------
Let me know how you get on
"Feeling a bit dim" - None of that please, we all learn on this forum. Funnily enough, I responded to a question 5 minutes after and the person was using measures in a calculated column.
As to the DAX, if I'm understanding it correctly the FirstFilesIndex returns blank if we're on the earliest row for each product (then put 0 in the column) but we don't need to do that, just check for Data[Index] = 0.
I don't really use EARLIER any more either - I prefer variables. Not really a problem though.
The index is probably not required either since you have the date field. Is it a problem performance-wise? Probably not.
Good luck.