Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a pretty simple sales scenario, where products are sold on a date basis for a brand and in a region.
Next to that I have a table with targets for the combination of a month, brand and region.
I would like to present the sales per date or month with the target line.
The target line should be adjusted if I filter the data to only showing one or a few brands and one or a few regions.
I am not sure how to link up the data and make this happen. Who can help me with a simple demo or some instructions on how to approach this?
Many thanks in advance!
Hi, @Anonymous
Could you share your current sample file and expected result for testing?
Best Regards,
Community Support Team _ Eason
@Anonymous
Similar to your actuals, you can also have a target table where you will have target sales value for each product, each brand for each region. In the date column, you can have the first day of the month as a start date. In this way, you can use the date in the target table to arrive at monthly calculation. below could be the structure of the target table. You can link target table with date column and other product and region table as well
Product | Brand | Region | Target Sale | Date |
Prod 1 | Brand 1 | North | 200 | 1-Jan-20 |
Prod 1 | Brand 2 | North | 100 | 1-Jan-20 |
Prod 1 | Brand 3 | North | 300 | 1-Jan-20 |
Prod 2 | Brand 1 | West | 300 | 1-Jan-20 |
Prod 2 | Brand 2 | West | 200 | 1-Jan-20 |
Prod 2 | Brand 3 | West | 100 | 1-Jan-20 |
Prod 1 | Brand 1 | North | 200 | 1-Feb-20 |
Prod 1 | Brand 2 | North | 100 | 1-Feb-20 |
Prod 1 | Brand 3 | North | 300 | 1-Feb-20 |
Prod 2 | Brand 1 | West | 300 | 1-Feb-20 |
Prod 2 | Brand 2 | West | 200 | 1-Feb-20 |
Prod 2 | Brand 3 | West | 100 | 1-Feb-20 |
Proud to be a Super User!
@negi007 Not sure this will work 😞
I will basically have a many to many relationship now, right?
ie My brand3 will be many times in the fact table and many times in the target table....
Any ideas how to resolve?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |