Forum Discussion

Robin96's avatar
Robin96
Icon for Helper II rankHelper II
2 years ago

Calculation if ID match

Hey all, i need to create a calculation that substract an amount from table1 from table2. (Amount from table1 - amount from table2). This should be based on if the ID's match. So if Reference ID f...
Need Help
Robin96's avatar
Robin96
Icon for Helper II rankHelper II
2 years ago

Hey, Thanks for the response! There is no relation between these two ID's in the original semantic model. They both relate to the date table i have. Is there a way to add this link with for example TREATAS in the column syntax?

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
2 years ago

Robin96 

then you change the column  to 

Column = maxx(FILTER('Table 1','Table 1'[id]='Table 2'[id]),'Table 1'[reference id])+0
  • Robin96's avatar
    Robin96
    Icon for Helper II rankHelper II
    2 years ago

    Hey,

    i get this response on the syntax in the DAX, what am i doing wrong here?

     

    • ryan_mayu's avatar
      ryan_mayu
      Icon for Super User rankSuper User
      2 years ago

      your DAX is different from mine. maybe try to remove the part after "-"