Help with Building Comparison Carts in Power BI

[Dineshbabu]

Hi Team,

I'm working on a Power BI project where I have several tables, including Products, Costs, and Past Selling History. The values in the Costs and Past Selling History tables only include unit prices per product.

The user wants to create three different carts that can have the same or different product selections, and they would like to compare the total prices of these carts. Additionally, I need a way for users to input quantities for each product in all three carts to calculate the total value.

I have a couple of questions:

1. Multiple Selections: Is it possible to allow users to select products from a single table for three different carts and store these selections separately for comparison?

Each String is a cart & will be having multiple Products.

1. User Input for Quantities: Can we enable users to enter quantities for each product in all three carts?

I appreciate your guidance on these requirements. Thank you!

[Anonymous]

Hi, @Dineshbabu 

Has your problem been solved? If not, can you provide some sample data and the output you expect? You can use Excel to present the data. Sensitive data can be removed in advance.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ritaf1983]

Hi @Dineshbabu 

please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly