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 , Please find the attached solution after the signature.
Create common dimensions, Joins, and few measures
for the qty, can we do live-to-date balance instead of just the balances for the month?
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
EdwardNg , one product has two description ??
