Creating Calculated Rows in a Matrix

[PBIEvangelist]

Hello!

I have a matrix and I am trying to add more than one calculated row. Please see example below. My initial thought was to try to create several measures for each Account Name for MTD, YTD, 1YR, etc. However, I am not sure where to start or if this is even possible using a matrix. Any help / Advice will be greatly appreciated.  Thanks!

Account Name	Account Detail	MTD	QTD	YTD	YR1
Account Name 1	Account Return	0.52	1.5	1.5	7.2
	Benchmark Return 1	0.48	1.68	1.73	8.29
	Benchmark Return 2	0.95	2.2	2.58	11.95
	Diff of Account Return and Benchmark Return 1)	0.04	-0.18	-0.23	-1.09	<-- New Calc
	Diff of Account Return and Benchmark Return 2)	-0.43	-0.7	-1.08	-4.75	<-- New Calc
Account Name 2	Account Return	0.6	1.95	1.2	8.3
	Benchmark Return 1	0.48	1.68	1.73	8.29
	Benchmark Return 2	0.95	2.2	2.58	11.95
	Diff of Account Return and Benchmark Return 1	0.12	0.27	-0.53	0.01	<-- New Calc
	Diff of Account Return and Benchmark Return 2	-0.35	-0.25	-1.38	-3.65	<-- New Calc

Step Layout is set to Off

[Anonymous]

Hi @PBIEvangelist 

Has your problem been solved ? If it has been solved, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards

Community Support Team _ Ailsa Tao

[amitchandak]

@PBIEvangelist ,Usually there is not way to add custom rows

You have to create a new table with these diff as account details with the account name. Join the current table and this new table with common account and account details and display.

[PBIEvangelist]

I have not been able to make this work. Calculating the differences in particular and formating in rows. I created a Layout with IDs to distinguish what is what in excel but I get stuck there. Is there anyway you can show me an example?

[PBIEvangelist]

Thanks so much for your response! I will try this out today.