Forum Discussion

aishak12's avatar
aishak12
Helper IV
5 years ago
Solved

Fixing Advanced Editor Error

Hi All, 

 

I am appending three queries together and would like to start in a fresh new file. I am attempting to copy over all the formula's I created in the old file. If anyone has an idea what the correct line should be, I would highly appreciate any help. 

 

 

Old File

 

New File:

 

 

 

Error attempt: 

 

 

  • aishak12 looking at image 3, you are missing a comma at end of line 5 and that's why you are getting errors on line 6.

     

    I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

3 Replies

  • aishak12 looking at image 3, you are missing a comma at end of line 5 and that's why you are getting errors on line 6.

     

    I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee

    You are missing a comma at the end of your #"Appended Query" step.

     

    Regards,

    Pat

  • Icey's avatar
    Icey
    Community Support

    Hi aishak12 ,

     

    Just as what parry2k and mahoneypat mentioned, you are missing a comma. Please check.

     

     

    Best regards

    Icey

     

    If this post helps, then consider Accepting it as the solution to help other members find it faster.