Forum Discussion
competition sales data analysis
If you can put together a table with a list of unique products you can create a relationship between your two tables and the unique product list. Once those relationships are in place you should be able to create a clustered column chart to show the sales for both your company and competitors next to each other. I would suggest using the product types as the axis and seeing where you get from there??
Best of luck
Hi Back2Basics, ,
I tried to do the same but somehow i am not able to see my brands sales qty on the same visual along with competitors sales qty. I want to show the week wise sales data comparision. I.e week no. on 1st slicer, Product Category on 2nd Slicer & brands on x axis in visual & sales qty on Y - Axis.
I can certainly utilise the idea shared by richbenmintz for creating a union between tables. Doing this on small tables with few thousands rows in each table is good but i am taking about tables that has more than 50 lakhs of rows each. Doing a union will be a temporary solution as over the period of time data will grow & PBI will strt showing lags.
Hope you understand my concern. Somehow i like the idea of v-jiascu-msft, I am wondering if my scenario can be mapped by creating multiple calculated tables. I have shared the dummy data for your better undersatndings.
Awaiting further ideas.
Regards,
Hemant