Forum Discussion

joannerw's avatar
joannerw
Helper I
4 years ago

Consolidating data from multiple columns

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:

 

 

Need Help

2 Replies

  • joannerw's avatar
    joannerw
    Helper I
    4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.