How to calculate a difference between quantities of different tables in the same date

[Anonymous]

Hello guys, i'm new here, and i have a stock control problem.

Here is the deal: 
I have 3 tables of data and one calendar table that i've created to relate them -> 

The two main tables are: "Documentos de Material"(Documents of Materials) and "LEVANTAMENTO" (Physical Stock Data), this are basically: Material data from SAP system and Real Physical Stock of Products.
The third table "DadosGeraisMaterial" is a complement of "Documentos de Material" that contains information like: the material names, because there's only the material number in "Documentos de Material".
I need to calculate a difference o quantities between System and Physical ("Documentos de Material" and "LEVANTAMENTO"),
And then, I need to be able to identify, with a table, a change in differences through time and create a graph showing it.

I've realized that i'm terrible at explaining it with words, so i drew it:

Please help me, i need my job lol.

[Anonymous · Accepted solution]

Hi @Anonymous ,

Below is my table1:

Below is my table2:

Below is my table3:

Below is my table4:

The following DAX might work for you:

Difference = 
    var Sys = SELECTEDVALUE(System[SysQty])
    var Phy = SELECTEDVALUE(Physical[Phy Qty])
    RETURN
       Phy-Sys

The final output is shown in the following figure:

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...