ADDCOLUMNS around a GENERATESERIES

[hannsen13]

Hello Mentor,

Could you help to identify my mistake(s)?

DAX:

HRI_IP = ADDCOLUMNS ((

        SUMMARIZE('HRI',

        ,HRI[Group]

        ,HRI[Lzentr_nm]

        ,HRI[WPE_%])

),

GENERATESERIES(0,399,5)          // PBI highlight this red

)

Error message: Argument '2' in SUMMARIZE function is required.

[ppm1]

You need to add the name for the new column added in " ", but GENERATESERIES returns a table so you will likely get a new error when you do. Are you trying to create many rows for each row of the summarized table? If so, are you sure you want to do that with DAX? If so, look at the GENERATE function.

Pat

[hannsen13]

I am trying to have them in columns.

GENERATESERIES(0,399,5)	HRI[Group]	HRI[Lzentr_nm]	HRI[WPE_%]

a

[hannsen13]

I have worked out a solution. Thank you for your time and effort in responding to my question.