Forum Discussion

MontsePuig's avatar
MontsePuig
Frequent Visitor
8 years ago
Solved

Add new column or new table? problem with date column

Hi everyone! :smileyhappy: 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 tw...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
MontsePuig
Frequent Visitor
8 years ago

Lydia,

Thank you very much. :smileyhappy: