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,
My example shows the fact that there is in SAP. But for 4,225,828.46 account is worng (It's my personal de facto decision, not formula result). This purchase in euro, that's why I need change account and then in my second transaction I will have negative effect, because my fact weighted average bigger than should be. And every previous buy/write off transaction is in formula, therefore, I don't know how to avoid it.(
Sorry but I think I am at a loss here, not sure i understand exactly what you are doing and pretty sure that the sum of the sum of the same calculation is not supported. If you can come up with an alternate way to weight and sum your data I could try again.
Sorry
Richard