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
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.