Forum Discussion

lavanyak's avatar
lavanyak
Advocate I
8 years ago

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...
Need Help
lavanyak's avatar
lavanyak
Advocate I
8 years ago

My data is at booking date level and has in total 26000 records, in which I have 1700 unique sectors.

I am trying to get the sum of sales for each of these 1700 sectors by grouping at sector level. Ideally in the result I should get 1700 rows but I am getting the results only for 358 sectors.

 

The data I gave is the sample of the results.

 

Hope it is clear now.

Gazzer's avatar
Gazzer
Resolver II
8 years ago

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!

  • lavanyak's avatar
    lavanyak
    Advocate I
    8 years ago

    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.