Channelwise Inventory Ageing report in Power bi
Budget: ₹400 – ₹750 INR
Need help in creating a measures and relationship that will help to create Channel wise Inventory Report.
Here Channel is comes from separate table(Channel master) and For Inventory values; you have to calculate first contribution of ageing 1-30,31-60,...365+ with total value which will come from (Site wise stock) and using these contribution you have to create new ageing from 1-30,31-60...365+ for (site and storage location wise Stock Table). In the final all operations should work on channel from channel master as we have to show channel wise inventory ageing
Here Channel is comes from separate table(Channel master) and For Inventory values; you have to calculate first contribution of ageing 1-30,31-60,...365+ with total value which will come from (Site wise stock) and using these contribution you have to create new ageing from 1-30,31-60...365+ for (site and storage location wise Stock Table). In the final all operations should work on channel from channel master as we have to show channel wise inventory ageing