Forum Discussion

HabibAdil's avatar
HabibAdil
Helper IV
6 years ago
Solved

Removing Records based on Conditions from two Different Columns

Hi All,   Please can somebody tell me how to do the attached in power query? I need to remove the quotes which have SO No and Opp records, if one are the other then keep the quotes.  
Need Help
HabibAdil's avatar
HabibAdil
Helper IV
6 years ago

Hi parry2k  Thanks for your reply. I am afraid I could not make it work. Just to mention I am new to power BI/Query. Please can you change your code to make it work for this?

The source table name is Quotes and it has the following fields.

Quote_No                          text

Quote_Version                  Whole Number

SO_No                              text

Opportunity_GUID           text

  • HabibAdil's avatar
    HabibAdil
    Helper IV
    6 years ago

    Hi v-xuding-msft Thanks for your help!!!!! It worked perfectly.

    • v-xuding-msft's avatar
      v-xuding-msft
      Community Support
      6 years ago

      😊I'm so happy that it works for you.