Forum Discussion
Sales Price for Generation Product
Community SupportHi Anastasija,
Based on your description, you create a measure to calculate the old sales unit price in Generation table, right? So what's the relationship between Date Key table and Generation table? Measures [Total Net Sales] and [Quantity sold] are based on which columns? And what's the logic of your measures?
In addtion, if possible, can you share some data and clarify more details to test?
Regards,
Jimmy Tao
Hi,
thank you for the support. Yes, I did a measure to calculate the Unit Price but not in the generation table, I did it in the Historical Turnover table.
Attached please find the example for the product with 2 generations.
The relation is between material numbers inbetween all tables. There is one Key table for material available as well.
The Date key is linked to Date in Cost table and in Historical Turnover table. So i thought that in such a case the calculation for generation should work, as the material numbers in the generation key table are as well linked to the historical table and cost table.
How can I share the Report with you? I prepared a small example and thought I could share it. Or how can I attach? I do not see any attachment options.
Regards,
Anastasija
- v-yuta-msft
Hi Anastasija,
You can share your sample file through cloud storage such as dropbox.
Regards,
Jimmy Tao