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

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.