Forum Discussion

Tomek1982's avatar
Tomek1982
Helper I
3 years ago
Solved

Stock value calculation over time

Hi,

I have following issue. 

There is a stock calculated over time based on a table with stock movement.

There is a measure calculating the stock and this is working fine:

The next step for me is to calculate stock value over time taking parts prices from another table:

It seems to be easy calculation: stock_value = parts_qty * part_price but I can not manage it. I would like to display changes over time. PBIX attached here

Need Help
  • Tomek1982's avatar
    Tomek1982
    3 years ago

    Thanks for the reply, actually in the original file the issue was much simpler. There was a mess in data types. After data types correction everything sarted to work as intended.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I m not understanding in 100% but if you want to use 2 different tables in calculation, than you must create relationships between them.

     

    In dax, use logical funtion to connect them. = related or relatedtable

     

     

    • Tomek1982's avatar
      Tomek1982
      Helper I
      3 years ago

      Thanks for the reply, actually in the original file the issue was much simpler. There was a mess in data types. After data types correction everything sarted to work as intended.

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi, 

        How did you in the end make the calculation to get the stock value?