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