Summarize function doesn't work

Anonymous · ‎07-29-2021

This post has closed.

Anonymous · ‎08-02-2021

@Anonymous

Show us the expect output from the above sql table.

Paul Zheng _ Community Support Team

Vera_33 · ‎07-30-2021

Hi @Anonymous

You are asking a DAX measure in Power Query...what is your expected result? You are not trying to replicate the sql query in DAX, right? When you said "I would like to obtain the start qty that is group by the max(date), process description, production ID", I don't see you group your table with [date]...

You need to provide some sample data and expecte result in a format which people can copy, then we can help.