Help on using M Code

[StuartPQY]

Hello

I hope someone can help.  

All my power queries to date have used a fixed drive letter on the path.  As my company is moving to SharePoint/One Drive.  I have tried the code below but it does just does not want to work.  I am trying to make my Power Query workbooks work for several users, some using online storage, some using fixed drive letters (network shares) Help?!

Thank you

Stuart

[v-cgao-msft · Accepted solution]

Hi @StuartPQY ,

Please try to convert IF to lower case if.

if

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[StuartPQY]

Gao, thank you.

I am now kicking myself I missed it...

Thanks

Stuart