Forum Discussion
Help with creating Matrix table Delta
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.
2 Replies
Hi Kieran-q_20
Please share sample data and screenshot of requirement
Thanks
PijushHi 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
