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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thank you Both. I will start to test it but it seems logical. I will come back if something is not clear for me.