Add Additional Column in Matrix and avoid repeating values

[binayjethwa]

Hi,

I have the following requirement where i need to show the current month + 3 months later alonw with week on week data in a matrix . 

Currently i am using a matrix visual and i am showing Week on week data as below.

Name	Number	location	City	06-Nov	13-Nov-23	20-Nov-23	04-Dec-23	11-Dec-23	18-Dec-23	25-Dec-23
Test	111	hyd	hyd	11	77	88	55	89	9	66
Test1	112	koc	koc	11	4	44	55	44	9	66
Test 2	113	tvm	tvm	11	4	88	6	89	4	66

I have a requirement where i need to show as below .  i need to show based on my data available current month with 3 months later and followed by same week on week data. and it should be dynamic , current month + 3 month always based  in on data in matrix data. Is this possible in matrix , how can we achieve.

Name	Number	location	City	Nov	Dec	Feb	Mar	06-Nov	13-Nov-23	20-Nov-23	04-Dec-23	11-Dec-23	18-Dec-23	25-Dec-23
Test	111	hyd	hyd	176	219	333	234	11	77	88	55	89	9	66
Test1	112	koc	koc	59	174	334	235	11	4	44	55	44	9	66
Test 2	113	tvm	tvm	103	165	335	236	11	4	88	6	89	4	66

[binayjethwa]

Hi @lbendlin  , 

I have a date table with week ending dates column , now i  have to show all the numbers for all the emp foe every week ending date , along with current month and 3 months more .

for example , this is the date column i am using.

Now i need to show the matrix table with below: 

In matrix

Rows: Name , Number , City ,Location

Columns : Date

Values : Total Hours 

Now here in matrix in columns i need to show current month + 3 monts and also week ending dates.

Note : My date table is mapped to emp table with date column.

Expected output as below : 3-4 months data with week on week. and these 3-4 months data should be dynamic and it will take current month as starting month.

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[lbendlin]

You are looking at measures - lots and lots of them. Make sure you are up for the maintenance .

(Look into Field Parameters - that might ease the pain a bit)

Where is January?

[binayjethwa]

Hi @lbendlin ,

Oh yeah i missed Jan ,  not many measures because i will have weeks column in column section of matrix and additionally i need those 4 or 5  dynamic months based on data in the matrix and since if i place multiple measures on Values section it will be repeated. SO need some solution where we can add more values in columns apart from week on week. Any suggestions ?

Basically my output should have 4 or 5  current months based on data available and then all the week on week data as below.

Name	Number	location	City	Nov	Dec	Jan	Feb	Mar	06-Nov	13-Nov-23	20-Nov-23	04-Dec-23	11-Dec-23	18-Dec-23	25-Dec-23
Test	111	hyd	hyd	176	219	33	333	234	11	77	88	55	89	9	66
Test1	112	koc	koc	59	174	33	334	235	11	4	44	55	44	9	66
Test 2	113	tvm	tvm	103	165	33	335	236	11	4	88	6	89	4	66

[lbendlin]

Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.