Forum Discussion
Dynamic SUMIFS function into calculated column by DAX
Dear friends, hello! My task is to create a 100,000 line pricing simulation. Unfortunately, excel cannot handle this amount. I tried to do it through DAX but I lack knowledge. Is it possible to make...
Dear richbenmintz ,
As I already answered, you are right, in my current example I have the same figuers in Column C and my simulation Column H. I did this to test the behavior of the transactions when calculating the weighted average. How I understand, I cannot avoid this recursive sumif of the same column. If somebody have any ideas, I'll be happy!)
richbenmintz
Resident Rockstar
Resident RockstarHi MKushpil,
I guess what i am trying to understand is, are you able to derive the simulation without summing up the sums in colum H. The dynamic range is not a problem the self referencing sum is the problem