Forum Discussion
Adrian_A
3 years agoFrequent Visitor
Group data in power query
Hello All! As most here I am hoping for some assistance. I to, am vary new to power Bi and its features. My goal is to group data in Power Query to look just like the below. I belive this is done...
Sri_phani
3 years agoHelper III
Hi Adrian,
You can use an option called "Group by", which will have advanced options to calculate as per your requirement.
You can add multiple groupings along with multiple calculations as mentioned below.
Adrian_A
3 years agoFrequent Visitor
Also, It appears any grouping creates a new column rather than displaying in same columns
Thanks for your help!