Forum Discussion
table.group
Hello, I am facing issues with Power query Table.Group. I am trying to get the sum of sales for each sector.In total I have 1700 sectors (OnD)), but I am getting results only for 358 sectors.I am n...
Hi lavanyak
Unfortunately, without seeing the actual data it is not possible to say why you are getting fewer unique values than you expect. All I can really suggest right now is to double-check that you are grouping by the right columns. Perhaps take the data into Excel and do some counts in there?
Sorry - I realize this is not particularly helpful!
Thanks for your response.
I crossed checked the data, using the same table if I group sales by sector in Power bi desktop visualization, I am getting total sales for all 1700 sectors.
I dont understand why I am not getting it in power query.