Forum Discussion

hongho2's avatar
hongho2
Frequent Visitor
2 years ago

New column

Hi, I am attempting to add a new column with the syntax  NewDate =IF(ISBLANK([#"Backlog[Ship Date]"]), [#"Delivery Date[Delivery Date]"], [#"Backlog[Ship Date]"]) It shows no syntax error  from sec...
Need Help
BA_Pete's avatar
BA_Pete
Super User
2 years ago

Hi hongho2 ,

 

You're trying to use DAX code in Power Query, which works on M code. It's also not so easy to reference across different tables (queries) as it is in DAX using relationships.

I would recommend using the code you're attempting within a DAX Measure in Desktop as it will be significantly more efficient than recreating the relationship behaviour within Power Query.

 

Pete