Calculated the difference between columns of a matrix visual

[Anonymous]

Hello Everyone,

I have a matrix in which, I am displaying volume of differtent stages at data load. Along with that, I want to show the difference of volume betweek two stages. 

I am placing the fields values in the following way in the matrix visual-

Also, the expected structure of matrix visual is as below-

Wave/Stage	Stage1	Stage2	S2-S1	Stage3	S3-S2	Stage4	S4-S2
Wave1	32	15	-17	13	-2	32	19
Wave2	50	15	-35	12	-3	5	-7
Wave3	55	55	0	55	0	55	0
Wave4	32	45	13	33	-12	33	0
Wave5	22	22	0	22	0	22	0

Please suggest ways to calculate and show the difference between two columns in visual.

@Pragati11 

@amitchandak @parry2k 

Please advise.

-Nikhil

[Anonymous · Accepted solution]

Hi @Anonymous 

I made a little format change to your source data. I use Pivot function in Query Editor to convert the values in field[Stage] to column names ,like [Stage1][ Stage2][ Stage3][ Stage4] .

The final data structure is shown in the figure .

Then return to Desktop View and add a Matrix visual in report .

Then create calculated columns to count the diff between two columns .

S2-S1 = 'Table'[Stage2]-'Table'[Stage1]

S3-S2 = 'Table'[Stage3]-'Table'[Stage2]

S4-S3 = 'Table'[Stage4]-'Table'[Stage3]

The final result is as shown :

I have attached my pbix file , you can refer to it .

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.