Add new column or new table? problem with date column

[MontsePuig]

Hi everyone! 

I need to add a new data in my Dashboard, the sales targets by category (office and Horeca goals), I want to compare the orders vs Goals for Month and MTD. I have tried two options without success.

1.- New Column. I have tried adding a new column in the same table with the condition option "if the month of the year is 1 then it corresponds to X". The result is the sum of all rows (several) of the month, this is false.m 
2.- New Table: I have uploaded the following table, the problem appears in the relationships.

Goals can be calculated by day or by month. The problem I don't understand is that in the "data orders" I have different rows with the same day. 

Can anybody help me?

Thank you very much.

[v-yuezhe-msft · Accepted solution]

@MontsePuig,

Create a date table following the instructions in this blog, then create the following columns in your original table.

Column = CALCULATE(SUM(Table[Orders]),ALLEXCEPT(Table,Table[HOvsOF]))
MTD = TOTALMTD(SUM(Table[Orders]),'Date'[Date],ALLEXCEPT(Table,Table[HOvsOF]))


If the above steps don't help, please share sample data of your original table that can be copied and pasted, also post expected result in table format.

Regards,
Lydia

[MontsePuig]

Lydia,

Thank you very much.