Forum Discussion
Dynamic Table based on Search
Dear all users I am new to PowerBi and taking an online course. However, my management wants something, and I am unsure I can solve it. Furthermore, I am having trouble finding a way to solve it, ei...
Resalat , create a date and Item table and join the two table with date and all three with item
Qunatity on hand = Sum(Present_stock[Current Stock]) - CALCULATE(Sum(Material_receive[MRN ]) ,filter(allselected(Date),Date[Date] <=max(Date[Date]))) +CALCULATE(Sum(Material_Issue[MRN ]) ,filter(allselected(Date),Date[Date] <=max(Date[Date])))
In this I have assume you want to generate past stock