Forum Discussion

ThomasWeppler's avatar
ThomasWeppler
Impactful Individual
5 years ago
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 anymore, while the first one starts to work.

Does anyone know where I made the mistake?

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

5 Replies

    • ThomasWeppler's avatar
      ThomasWeppler
      Impactful Individual
      5 years ago

      Sure

       

      Summarized table =
      VAR x1 =
      SUMMARIZE (
      '2891_assignment',
      '2891_assignment'[assignmentNumber],
      '2891_assignment'[deadline],
      '2891_assignment'[estimate],
      '2891_assignment'[startdate],
      '2891_assignment'[timeusage],
      "Estimate hours",
      DIVIDE('2891_assignment'[estimate], 60),
      "Registered hours",
      DIVIDE('2891_assignment'[timeusage], 60),
      "Sub assignment estimate",
      DIVIDE(
      SUMX (
      FILTER ( ALL ( '2891_assignment' ), [Underopgver] = EARLIER ( '2891_assignment'[assignmentNumber] ) ),
      [estimate]
      ), 60),
      "Sub assignment registration",
      DIVIDE(
      SUMX (
      FILTER ( ALL ( '2891_assignment' ), [Underopgver] = EARLIER ( '2891_assignment'[assignmentNumber] ) ),
      [timeusage]
      ), 60)
      )
      RETURN
      FILTER (
      ADDCOLUMNS ( x1, "total estimate", [Estimate hours] + [Sub assignment estimate]),
      [Sub assignment estimate] <> BLANK ()
      )
      FILTER (
      ADDCOLUMNS ( x1, "total Registration", [Registered hours] + [Sub assignment registration]),
      [Sub assignment registration] <> BLANK ()
      )
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello ThomasWeppler 
    Please check the below codes and change the table and measures accordingly.
    Summarized table =
    VAR x1 =
    SUMMARIZE (
    'Recordings',
    'Recordings'[ID],
    'Recordings'[Actor],
    Recordings[Hour],
    "Estimate hours", DIVIDE ( Recordings[Hour], 60 ),
    "Registered hours", DIVIDE ( Recordings[Hour], 60 ),
    "Sub assignment estimate",
    DIVIDE (
    SUMX (
    FILTER ( ALL ( Recordings ), Recordings[Hour] = EARLIER ( Recordings[Hour] ) ),
    Recordings[Hour]
    ),
    60
    ),
    "Sub assignment registration",
    DIVIDE (
    SUMX (
    FILTER ( ALL ( Recordings ), Recordings[Hour] = EARLIER ( Recordings[Hour] ) ),
    Recordings[Hour]
    ),
    60
    )
    )
    VAR x2 =
    FILTER (
    ADDCOLUMNS (
    x1,
    "total estimate", [Estimate hours] + [Sub assignment estimate]
    ),
    [Sub assignment estimate] <> BLANK ()
    )
    VAR x3 =
    FILTER (
    ADDCOLUMNS (
    x1,
    "total Registration", [Registered hours] + [Sub assignment registration]
    ),
    [Sub assignment registration] <> BLANK ()
    )
    RETURN
    UNION ( x2, x3 )