Consolidating data from multiple columns

[joannerw]

Hi. I have a data set the has multiple entries for chemical and quanitities, but I need to total all quanities for each user. An mock example is as follows:

[v-xiaoyan-msft]

Hi @joannerw ,

Please see if the ariticle helps:

Shape and combine data in power bi  

If I have not understood your needs correctly, please do not hesitate to inform me.

Hope it helps,

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[joannerw]

I'm also using direct queries and would like to maintain this if possible