Forum Discussion
Data model
Hi Can you assist with my data model as the data tables are aggregates as opposed to having a primary key. What would my model look like to be able to see per item cost versus revenue targets for it...
hello Anonymous
please check if this what you need.
1. Create relationship of your 'Date' table to 'Table 1' and 'Table 2'.
- 'Date' to 'Table 1' -> Date
- 'Table 1' to 'Table 2' -> Item
2. Plot you Date and Item into slicer visual. While Cost and Revenue in card visual.
Hope this will help you.
Thank you.