Forum Discussion
Solved
Calculating MTM Value based on Month End Position with Last Price
Hi, I have 2 tables, Price and Transactions. Example as below: Price Table Date Product Price 2/1/2020 A 1.5 29/1/2020 A 1.3 2/2/2020 A 1.25 28/2/2020 A 1.2 2/1/2...
EdwardNg , Please find the attached solution after the signature.
Create common dimensions, Joins, and few measures
amitchandak thanks for the prompt response.
Also, if i have additional fields in the transactions i want to display in the summary, it gives me a problem. For example if we have product description, it gives the permuatation, as below:
Could you kindly advise? appreciate your thoughts on this.
Many thanks
amitchandak
Super User
Super UserEdwardNg , one product has two description ??
each product only has 1 description. But this is probably just the simplified version. There could be other fields like company, etc. So each product could be have different values for company. hope this is clear.