Forum Discussion

AndreaMeras's avatar
AndreaMeras
Frequent Visitor
6 years ago

Filter Database before grouping columns

Hi!

 

I have a database that I need to group by Order Number (because each order has several lines). The problem that I have is that sometimes, an order is related to 2 different work centers, so, if I group by order number I cannot add the workcenter column cause is not unique per order.

So, in my mind, the solution would be to filter de DB by workcenter before grouping the columns (summarizing) but how can I do that inside power BI without touching the db?

 

Hope I explained it

Regards, Andrea

Need Help

2 Replies

  • mhossain's avatar
    mhossain
    Solution Sage
    6 years ago

    Hi AndreaMeras 

     

    In powerquery you can groupby by two columns Order and workcenter. Please explain more what exactly you want to achieve.