Help with creating Matrix table Delta

[Kieran-q_20]

Hi All,

I've been using chatbots but i cannot find a way to create a total column in a matrix for the difference between two columns. The columns in this Matrix are ordered by a fiscal week column in my dataset.Would it be possible to create an additional column that could show the Delta between weeks 35 and 36 for example? 

Any help is really appreciated, thank you. 

[PijushRoy]

Hi @Kieran-q_20 

Please share sample data and screenshot of requirement

Thanks
Pijush

[Kieran-q_20]

Hi Pijush,

I have attatched a sample of the data at the bottom below, unfortunately i could not use the exact data as it is for work but i recreated the file with only relevent information to my request. In the sample data is three columns, the SLOC column is an identifier which makes up the rows of my matrix in PowerBI, the total cost column makes up the values in my PowerBI matrix and finally the calender week column would make up the columns in my matrix. 

The screenshot attatched below shows my requirment, is there a way to create an additional column here in this matrix that would show the Delta between the displayed Weeks? 

SLOC	Total Cost	Calender Week
BRS1	0.04	Week 36
RMA1	3305.75	Week 36
INT1		Week 36
DRS6		Week 36
RMA1		Week 36
RMA1		Week 36
RMA2	0	Week 36
RMA4	397028.04	Week 36
INT1	28557.05	Week 36
DRS6		Week 36
INT2	154721.58	Week 36
DRE2	191175.72	Week 36
DRE6	102163.72	Week 36
DRS6	0	Week 36
DRS1	51158.67	Week 36
EX02	869171.11	Week 36
EX06	50767.37	Week 36
DRT2	0	Week 36
IC01	208456.87	Week 36
HP01	0	Week 36
HP02	2879.01	Week 36
LOG1	119196.2	Week 36
LOG2	1092.57	Week 36
LOG8	643.86	Week 36
BRS1	0.04	Week 37
RMA1	3305.75	Week 37
RMA2	0	Week 37
RMA4	397028.04	Week 37
INT1	28557.05	Week 37
INT2	154721.58	Week 37
DRE2	191175.72	Week 37
DRE6	102163.72	Week 37
DRS6	0	Week 37
DRS1	51158.67	Week 37
EX02	869171.11	Week 37
EX06	50767.37	Week 37
DRT2	0	Week 37
IC01	208456.87	Week 37
HP01	0	Week 37
HP02	2879.01	Week 37
LOG1	119196.2	Week 37
LOG2	1092.57	Week 37
LOG8	643.86	Week 37
RMA1	0	Week 38
RMA1	51158.67	Week 38
RMA2	869171.11	Week 38
RMA4	50767.37	Week 38
INT1	0	Week 38
DRS6	208456.87	Week 38
INT2	0	Week 38
DRE2	2879.01	Week 38
DRE6	119196.2	Week 38
DRS6	1092.57	Week 38
DRS1	643.86	Week 38
EX02	0	Week 38
EX06	51158.67	Week 38
DRT2	869171.11	Week 38
IC01	50767.37	Week 38
HP01	0	Week 38
DRE6	208456.87	Week 38
DRS6	0	Week 38
DRS1	2879.01	Week 38
LOG8	119196.2	Week 39
RMA1	1092.57	Week 39
RMA1	643.86	Week 39
RMA2	0	Week 39
RMA4	51158.67	Week 39
INT1	869171.11	Week 39
DRT2	50767.37	Week 39
IC01	0	Week 39
HP01	208456.87	Week 39
DRE6	0	Week 39
DRS6	2879.01	Week 39
DRS1	119196.2	Week 39
DRS6	1092.57	Week 39