Solved: Syntax Conflict between Advanced Editor and Custom... - Page 2

Strickleyt · ‎09-12-2018

Screenshot of Error and Conflict

Please look at this snapshot which shows my code. I don't understand what the conflict is for the Express.Error presented when it clearly shows 'no syntax errors have been detected'. Can someone help me? This code works fine when I use in the Presentation Layer and create a calculated column to determine my last weekend. I use TODAY or NOW and both work fine there. I appreciate the assist, I have searched forums and cannot find any help

Strickleyt · ‎09-12-2018

With no disrespect, I hesitate to say this is resolved as your answer only points out the obvious which is incredibly frustrating to a user looking for a real answer that doesn't involve learning yet one more language and the 'custom column' builder should have taken care of this or give me a message 'DOESNT WORK NEED POWER QUERY M SYNTAX- if this were written obviously somewhere then I would take it as a known universal answer and would have never tried the approach provided in Power BI. These nuances are not straight forward and I know I am not the only person having issues with these 'nuances' that are just horrible. It's like throwing spaghetti at a wall constantly to see what sticks. Users shouldn't have to do that.

View solution in original post