Forum Discussion

Misha's avatar
Misha
Icon for Helper II rankHelper 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

 

4 Replies

  • mwegener's avatar
    mwegener
    Icon for Most Valuable Professional rankMost Valuable Professional

    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
    Icon for Community Support rankCommunity Support

    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
    Icon for Most Valuable Professional rankMost Valuable Professional

    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
      Icon for Helper II rankHelper II

      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