Multiple Tables with Allmost same columns

---

Anonymous wrote:

Is there a way to write a measure in an Appended table.

---

There sure is, provided you have some column that lets you identify the revenue, direct cost, travel cost and material cost. If you have those specific values in some column (eg. [Account Type]) you could write something like the following: 

Revenue = CALCULATE( SUM('Appended Table'[Amount] , 'Appended Table'[Account Type] = "Revenue")

Or if you have a list of values that define revenue you could do something like the following:

Revenue = CALCULATE( SUM('Appended Table'[Amount] , 'Appended Table'[Account No] IN {1000, 1100,1200})

Or if you had a range of Account numbers you could do something like the following:

Revenue = CALCULATE( SUM('Appended Table'[Amount]
  , FILTER(VALUES('Appended Table'[Account No]) 'Appended Table'[Account No] >= 1000
  , FILTER(VALUES('Appended Table'[Account No]) 'Appended Table'[Account No] <= 1999 )

)