Forum Discussion

PreetiSahu321's avatar
PreetiSahu321
Icon for Helper I rankHelper I
6 years ago

Subtract two columns from different table using DAX in power bi

Hello Power BI Community Members,   Recently, I was working with Power BI DAX. As per my requirement, I have to subtract two different columns of values from two different tables. Let me explain to...
power bi
POWER BI Dax rules
Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
6 years ago

Hi PreetiSahu321 
If I understand your issue, try this.

Subtract measure = SUM(Orders[Sales Doc])-Sum(Sales[Order])

 


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

  • PreetiSahu321's avatar
    PreetiSahu321
    Icon for Helper I rankHelper I
    6 years ago

    Hi Nathaniel_C ,

     

    I have applied the formula and it is giving me the exact value. But one more thing I want to know is, there is one common column in both Orders and Sales tables i.e. BillDate (Date and Time Datatype). As per my requirement, I want to subtract the measure per monthly basis. Let me explain to you properly.

     

    You can see below are two tables as Orders and Sales. I want to subtract the values from Net value to Sales US$ of the current month. As this is November month is going on, So it will subtract the values for the current month only. i.e. (132454-370.80=132,083.2)

     

     

    Can you suggest me if anything I have to do else?