Forum Discussion

Misha's avatar
Misha
Helper II
6 years ago

Advanced Editor: if...then count...

Hi Forum,

 

I have this situation and i can't get the right result: I want to add an additional column where the value is the sum of some values a condition is fullfilled, if not it should be empty. Attached the situation I mean.

 

It would be great if someone could help me so thx in advance! Kind regards

 

Need Help

4 Replies

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    Hi Misha ,

     

    check this out.

    PBIX

    Regards,

    Marcus

    Dortmund - Germany
    If I answered your question, please mark my post as solution, this will also help others.
    Please give Kudos for support.

  • dax's avatar
    dax
    Community Support
    6 years ago

    Hi Misha , 

    You could refer to mwegener 'susggestions. If this is not what you want, could you please inform me your logic of below image,

    and inform me more detailed information (such as your sample data and your expected output), then I will help you more correctly.

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    Hi Misha 


    is your problem solved?
    If I answered your question, please mark my post as solution, this will also help others.
    Please give Kudos for support.

    • Misha's avatar
      Misha
      Helper II
      6 years ago

      Excuse me for the delay. I do not want to be impolite and a quick screening gave me the impression the provided solution is satisfying but I haven’t found the time yet to investigate that thouroughly. You may be sure I 'll answer that in a short term!

      Thanks fort he reminder