Forum Discussion

Rochejf's avatar
Rochejf
Frequent Visitor
3 years ago
Solved

Return yes when all rows are filled

Hi guys, I'm wondering whether this can be done in Powerbi?   Referring to the table below.   I have 3 sales orders each separate into different sales tasks. What I wish to do now is, when all sa...
Need Help
Tips and Tricks
Tutorial Requests
  • ryan_mayu's avatar
    ryan_mayu
    3 years ago

    Rochejf 

    you can create a new column

    Column = if(CALCULATE(count('Table (2)'[Sales Date]),ALLEXCEPT('Table (2)','Table (2)'[Sales Order]))=CALCULATE(count('Table (2)'[Sales Task]),ALLEXCEPT('Table (2)','Table (2)'[Sales Order])),"Y","N")

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
3 years ago

Rochejf 

you can create a new column

Column = if(CALCULATE(count('Table (2)'[Sales Date]),ALLEXCEPT('Table (2)','Table (2)'[Sales Order]))=CALCULATE(count('Table (2)'[Sales Task]),ALLEXCEPT('Table (2)','Table (2)'[Sales Order])),"Y","N")

  • Rochejf's avatar
    Rochejf
    Frequent Visitor
    3 years ago

    OMG, this actually works!!! Really appreciate your help!!!!!! 

    • ryan_mayu's avatar
      ryan_mayu
      Icon for Super User rankSuper User
      3 years ago

      you are welcome

      • Rochejf's avatar
        Rochejf
        Frequent Visitor
        3 years ago

        One more question, if i want to perform this in power query format is it possible?