Forum Discussion
Complex Stock Allocation Logic
Hi, I am trying to allocate stock to sales orders using DAX, PowerBI. But the allocation logic is not straight forward. This is how the logic must work - 1. Check if Main warehouse ...
Hi sh-smita ,
Please attach your pbix file or copy and paste the different tables from Excel. That gives us the ability to play with the DAX and provide you a solution.
If you would share your pbix, or dummy up some values in Excel both for current and expected data. Please copy and paste them into your post, rather than doing a picture, we may be able to help you.
Please read this post to get your question answered more quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Nathaniel