Forum Discussion
Group by
Hello Beautiful People, Please I have a quesion. How can I group values into multiple groups in power bi. Example, I have a value in a "manager column" and this value manages two groups at once....
Current tableExpected resultI want the component body to be in two or more groups. When I use the group by function in poower bi, It only allocates it to one group. How can I achieve my result please?
Thank you
For this the best option is use DAX, in this case you can use SUMMARIZE, but this option is for create a new table, if you want to do it on the current table you should do it on the EDIT QUERIES and there is an option called GROUP BY.
Good Luck.
How do i do this in query without writing a long line of code? And i dont want to summarize, I just want to allocate the components to its indivual group. This sounds simple but hard to accomplish
Hi,
Can you paste a small dataset and show the expected result for that small dataset?
