Filter Database before grouping columns

[AndreaMeras]

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

[mhossain]

Hi @AndreaMeras 

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

[parry2k]

@AndreaMeras maybe share sample data and expected output and that will help to guide the best solution.