Part2 - Sum categories on rows and by months on columns into a Visual table

[Gigi4691]

Hi,

Please read my 1st email on 08-01-2024 08:20 AM, subject 'Sum categories on rows and by months on columns into a Visual table'.

I tried your solution but the Totals are wrong. Can we use 'Don't Summarize' into a Measure?  

Here is my result with your solution but the Totals are wrong:                                     and there is no 'Don't summarize' 

'Services final' is my category.

   

Example for January, with the good values, using 'Don't summarize':

       

As I explained into my 1st email, we cannot use a 'Matrix'. The person who will use the report, needs to extract it in Excel, but with a Matrix, it is not the same visual.

Thank you so much in advance !

[Gigi4691 · Accepted solution]

I  added the year in my formula but it did not solve the problem. I removed duplicates 'Project ' number into my 2nd table and it is now fixed.  Thank you for your help! 

[Anonymous]

Hi @Gigi4691 

Based on your picture,do you add the current year as 2024 to your formula, for example

Measure =
CALCULATE (
    SUM ( table[sales] ),
    YEAR ( table[date] ) = 2024,
    MONTH ( table[date] ) = 1
)

If this method still doesn't solve your problem, can you provide some sample data, because you can't provide an accurate scenario based on your pictures alone.

Best Regards!

Yolo Zhu

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