Forum Discussion

MKushpil's avatar
MKushpil
Regular Visitor
6 years ago

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...
Need Help
richbenmintz's avatar
richbenmintz
Resident Rockstar
6 years ago

MKushpil ,

In all cases in your sample data the Value TranCurr Simulation is the same as the Value Tran, are you sure the formula provides the values you want. If not is there are different way to generate the simulation withour having a recursive sumif of the same column?

MKushpil's avatar
MKushpil
Regular Visitor
6 years ago

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's avatar
    richbenmintz
    Resident Rockstar
    6 years ago

    Hi 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