Forum Discussion

MightyRabbit's avatar
MightyRabbit
Frequent Visitor
3 years ago
Solved

Query to subtract column from different Table

Dear all,  Could you please kindly help with the querry to subtract 1 column from another table. I have "table 1" with Column "No" Like the one below: No A1 A2 A1 A2 A3 ...
Need Help
  • rubayatyasmin's avatar
    rubayatyasmin
    3 years ago

    Hi, MightyRabbit 

     

    try to use calculate and all with IF and NOT DAX func

     

    the code will be something like

     

    Result = 
    CALCULATE(
        IF(
            NOT(CONTAINS(table2, table2[No_deleted], table1[No])),
            table1[No],
            "0"
        ),
        ALL(table2)
    )

     

rubayatyasmin's avatar
rubayatyasmin
Community Champion
3 years ago

Hi, MightyRabbit 

 

try to use calculate and all with IF and NOT DAX func

 

the code will be something like

 

Result = 
    CALCULATE(
        IF(
            NOT(CONTAINS(table2, table2[No_deleted], table1[No])),
            table1[No],
            "0"
        ),
        ALL(table2)
    )