MEGA QUESTION FOR MATRIX VISUAL

[Anonymous]

Hi community,

I have a question that Im affraid is not possible to be answered unless someone mega PRO. (crossing fingers)

I need to add 2 columns in my Matrix only for december and not to be in the total.

Anybody has an Idea how I could possibly solve something like this at least close to a solution?

[v-lili6-msft · Accepted solution]

HI, @Anonymous

You may try this simple way as below:

Step1:

Select matrix visual then Format->Column headers->Word wrap, disable it.

Step2:

Add a measure for "two columns" like this 

Measure 3 = CALCULATE(SUM(Table1[Qty]),FILTER(Table1,MONTH(Table1[Date])=12))

Step3:

Drag the measure into value and set width for october and November like this:

Best Regards,

Lin

[AlB]

Hi @Anonymous

If I understand correctly what you need, I think we solved something similar in this post.

Check it out.