Forum Discussion

SvenJ's avatar
SvenJ
Icon for Helper III rankHelper III
4 years ago

Getting a sum of a specific colum

I have to add a column dynamically. How can i get a sum in advanced editor -> f. ex   I need the sum added to colum 1051 of the column "Umsatz Values" where "BWA Zeile" has the value "1051" ...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

My previous post was showing an implementation as a measure. You seem to prefer an implementation as a calculated column or directly in Power Query? Do you want to create additional columns for each rule, or do you want to replace existing values in the same column?

SvenJ's avatar
SvenJ
Icon for Helper III rankHelper III
4 years ago

Do you want to create additional columns for each rule

 

Yes, as it is not 100% clear, how the structure is at the end. I would prefer the easiest way. What's the most "safe" way?

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    From a data preparation perspective the safest way is not to destroy any information - this means creating new columns for each of the rules.

     

    From a data visualization perspective that is the worst possible outcome.

  • SvenJ's avatar
    SvenJ
    Icon for Helper III rankHelper III
    4 years ago

    What's your suggestion? ... and maybe solution?

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    I would keep the source data as is and would implement the logic in DAX, similar to what I have shown for the 1080 case.

  • SvenJ's avatar
    SvenJ
    Icon for Helper III rankHelper III
    4 years ago

    Can you give me an example how to add a second rule? Maybe i can get it down by myself if i have an example.