Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

New column based on fixed amount

Hi   I've got two tables named Procurement and Stock. Procurement contains columns "Confirmed delivery date" and "Procurement Amount". Stock contains columns "Available stock", which is a current...
column
Date
DAX
Help
selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
5 years ago

Hey Anonymous ,

 

when you have a column with the procurement amount and no other column, then it's hard to calculate the new amount. Do you have another column that shows the consumption of the product in the time frame?

 

I also don't know what I should do with the column "Available Stock". You write -377 every row but I don't see that you really use that column.

 

 Could you explain your columns a little better?

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis