Forum Discussion
Create New Table with row count
HELP! I want to create a new table like I've created in an Excel. I've made a yellow table(right) from a pivot table(left). I will appreciate your help!
No, this is not what I want but thank you so much for your efforts. I really appreciate it.
I am very close to complete this process.
This is what I need in new table.
And this is what I got in new table.
I am just figuring out how will I get those count of user id in new column.
Hi hello_MTC ,
There are two simple methods to achieve the outcome:
Power Query
1. duplicate/reference the existing table,
2. then use group by:
.2a. Home > Group By:
Power BI report
pivot table in Power Bi
Regards
KT