Forum Discussion
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...
Oh, I get it, you are looking for the exact view in Power Query, then I don't think it is possible. Why because every aggregation that you do will create a column or transform the current one. So you can't create exact view that you are expecting.
Ok thankyou.
So then, would thier be away to achieve somthing similar? Lets say, in a drill down fashion?
Maybe drill down from a job# ? or would that end up creating a rediculous amount of colmns?
