Forum Discussion

cottrera's avatar
cottrera
Post Prodigy
4 years ago
Solved

Power Query IF Statement

Hi    I have a table with the following columns Ref, VAT Code, VAT Amount, VAT Amount query119. The table is 100,000 rows long and will continue to grow. I need to create a custom column in power q...
Need Help
  • manikumar34's avatar
    manikumar34
    4 years ago

    cottrera , Use conditional column which uses IF , Then and else .

Anonymous's avatar
Anonymous
Not applicable
4 years ago

cottrera Add custom column with this code:

if [VAT Code]="F2" then [#"VAT Amount"] else [#"VAT Amount - Query 119"]

  • cottrera's avatar
    cottrera
    Post Prodigy
    4 years ago

    Hi Marik thank you for your quick response. I tried the customer column method but received and error

    So I then tried manikumar34 option.
    thank you anyway