Variance between two date values of specific stage

Question

Hi sir,mam,&nbsp;Thanks for looking into the queruy.&nbsp;I have data as given below. I want to find the variance between two dates in sequence and show the same in a line chart. How can I achive the same?&nbsp;I have given the example of output as well as base data&nbsp;Both Base data tables (Stage table and amount tables are connected with each other with ID column.)Base data-&nbsp;Stage tableIDDateStage116-10-23A216-10-23A316-10-23A417-10-23A517-10-23A617-10-23A718-10-23A818-10-23A918-10-23A1016-10-23B1116-10-23B1216-10-23B1316-10-23B1417-10-23B1517-10-23B1617-10-23B1717-10-23B1818-10-23B1916-10-23C2017-10-23C2117-10-23C2217-10-23C2317-10-23C2417-10-23C2517-10-23C2618-10-23C2718-10-23C&nbsp;Base data-&nbsp;Amount tableIDAmount179238315468516626786884958102011631286135914211572167617521865194620182149224623372444254726782764&nbsp;Output table visual expected as below&nbsp;Column A, B and C are calculated as total amount of all IDs that are having respective date and stage.&nbsp;Column Variance are calculated by deducting the latest date value from previous date value.&nbsp;DateAVariance ABVariance BCVariance C16-10-231320228046017-10-23110-22221-724119518-10-2322811865-156142-99&nbsp;I could achieve generation of column A, B and C. How do I bring the variance column values to the table visual?&nbsp;Regards,Harshad

ashish_mathur · Accepted Answer

Hi,
PBI file attached.
Hope this helps.

&nbsp;

Forum Discussion

Variance between two date values of specific stage

1 Reply

Related content

Budget, actual and variance matrix

Variance bar chart

Specific matrix

Stacked bar charts with variance

How to create variance field and variance %

ID	Date	Stage
1	16-10-23	A
2	16-10-23	A
3	16-10-23	A
4	17-10-23	A
5	17-10-23	A
6	17-10-23	A
7	18-10-23	A
8	18-10-23	A
9	18-10-23	A
10	16-10-23	B
11	16-10-23	B
12	16-10-23	B
13	16-10-23	B
14	17-10-23	B
15	17-10-23	B
16	17-10-23	B
17	17-10-23	B
18	18-10-23	B
19	16-10-23	C
20	17-10-23	C
21	17-10-23	C
22	17-10-23	C
23	17-10-23	C
24	17-10-23	C
25	17-10-23	C
26	18-10-23	C
27	18-10-23	C

ID	Amount
1	79
2	38
3	15
4	68
5	16
6	26
7	86
8	84
9	58
10	20
11	63
12	86
13	59
14	21
15	72
16	76
17	52
18	65
19	46
20	18
21	49
22	46
23	37
24	44
25	47
26	78
27	64

Date	A	Variance A	B	Variance B	C	Variance C
16-10-23	132	0	228	0	46	0
17-10-23	110	-22	221	-7	241	195
18-10-23	228	118	65	-156	142	-99