Forum Discussion
Helper INew to Power Bi
Please help me out on the below:
Suggest best method to collect the excel files(Table 3) from various Stores where in daily data is updated by store person and is used to calculate the below and also guide me in calculating the below with steps from power query to visualization.
1. Calculating Daily sales based on price details on Table 2 (with date condition).
2. Displaying Product ID's for the sales less than average sales for custom date selection.
(Example Output:)
Store ID - Product ID
1B1C1 - 1B1C1I1
1B1C1 - 1B1C1I3
1B1C2- 1B1C2I4
3. Count the No. of products by Store ID for the sales less than average sale for custom date selection.
(Example Output):
Store ID - No. of Products below average sales
1B1C1 - 3
1B1C2 - 1
Source Tables below:
Expected output(samples):
2 Replies
- amitchandak
Super User
sriramk , Table 3 Need to unpivoted and you will get product and sales qty. Then it you need create a column it table 3 using table 2 to get the price
then you should able to get required data
https://radacad.com/pivot-and-unpivot-with-power-bi
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
sriramkPlease suggest a measure for
1. above and below average values
2. Color code(above avg: "Green" and below avg: "Red") in Clustered column chart with average line
