Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Sum some categories for the same date

dear all,   Please help me to solve a problem. I'm a beginner and I need to solve a problem. I attached a sampe data. I want to group all the fruits belonging to a certain date. The reason is tha I...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous 

     

    amitchandak  GOOD ANSWER!

     

    Here are my additions:

     

    You can create a calculated column.

    Type1 = SWITCH(TRUE(),
[Type] = "apple" || [Type] = "bannana" || [Type] = "orange", "fruits",
[Type] = "Bicycle", "Car",
[Type] = "house", "House",
[Type] = "PC", "PC")

     

    And a measure.

    Sum = CALCULATE(SUM('Table'[Cost]), ALLEXCEPT('Table', 'Table'[Type1], 'Table'[Date]))

     

    Or do the following:

     

    Output:

     

    Is this the result you expect?

     

    Best Regards,
    Yulia Xu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.