Forum Discussion
Solved
Computing purchasing price fluctuation year over year
Hi Everyone, I am struggling with the calculation of purchasing price fluctuation (variance) when it comes to items that where discontinued in middle of year N and replaced by a new item which ba...
Hi KARIM-K ,
Need an association between items 1 , 3 and 4. The data currently displayed is not enough to create an association.
Best Regards,
Jay
Hi KARIM-K ,
Need an association between items 1 , 3 and 4. The data currently displayed is not enough to create an association.
Best Regards,
Jay
Hi jay,
Thanks for your mail. If I add a new column stating the association between the 3 items does it help to figure out the solution and write down the appropriate dax function to get the appropriate result.
For the new Column, we can introduce a join item ID:
Item ID Item ID Join 1
1-3-4 2 2 3 1-3-4 4 1-3-4 5 5 Does it make sense ?
Best Regards,
Karim
