Forum Discussion

Khomotjo's avatar
Khomotjo
Helper II
1 year ago
Solved

Pivot table multi-column table

Good Morning Everyone,   I have data that summarises orders for a warehouse but it is at an ordeline level. I want to filter out all the orders where one or more order lines should not be picked , ...
Need Help
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    1 year ago

    Thankyou, Cookistador, for your response.

    Hi Khomotjo,

    We appreciate your inquiry on the Microsoft Fabric Community Forum.

    Please find attached the screenshot and the PBIX file, which may assist you in resolving the issue:

    If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will help other community members who may have similar queries.

    Should you have any further questions, please feel free to reach out to the Microsoft Fabric Community.

    Thank you.

Khomotjo's avatar
Khomotjo
Helper II
1 year ago

Thanks Cookistador  

If you look at the data you will see that an order has multiple order lines  some  of the lines can be picked and others cannot be picked. I want to exclude an order from the table if 1 or more lines cannot be picked.

 

I want to do this  on the data so I can  write it out into a sharepoint list to share with the warehouse