Forum Discussion
Solved
Syntax error when add multiple colums
Hi, I try to create a new table with multiple new colums, but I get a syntax error. When I Ctrl+X Ctrl+V the last lines of code and swift the positions of the two filters the later will not work an...
Hi ThomasWeppler ,
You can change the Dax function after Return to try the following sub-functions:
Var x2= Filter( ADDCOLUMNS(x1,”total estimate”,[Estimate hours] + [Sub assignment estimate] ), [ Sub assignment estimate] <> BLANK()) Return filter( ADDCOLUMNS ( x2,”total Registration”,[Registered hours] + [Sub assignment registration]), [Sub assignment registration] <>BLANK())Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello ThomasWeppler
Check your second last filter end bracket.