dex formula comparing figures on two dates in power bi

[MMudasir]

Data Exel / Table

Item No	Amount	Dates	Main Item
0010	265.61	31-March-2023	Banana
0014	383.13	31-March-2023	Banana
0015	180.23	31-March-2023	Banana
0017	203.75	31-March-2023	Banana
0039	214.21	31-March-2023	Banana
0044	149.86	31-March-2023	Banana
0091	320.46	31-March-2023	Banana
0111	121.48	31-March-2023	Banana
0113	200.26	31-March-2023	Banana
0122	132.47	31-March-2023	Banana
0128	90.66	31-March-2023	Banana
0136	77.86	31-March-2023	Banana
0137	110.17	31-March-2023	Banana
0157	52.41	31-March-2023	Banana
0158	61.59	31-March-2023	Banana
0010	264.46	31-March-2023	Retail
0014	304.82	31-March-2023	Retail
0015	174.67	31-March-2023	Retail
0017	186.86	31-March-2023	Retail
0039	214.21	31-March-2023	Retail
0044	149.50	31-March-2023	Retail
0091	317.04	31-March-2023	Retail
0111	120.85	31-March-2023	Retail
0113	200.26	31-March-2023	Retail
0122	106.91	31-March-2023	Retail
0128	90.61	31-March-2023	Retail
0136	77.86	31-March-2023	Retail
0137	110.17	31-March-2023	Retail
0157	52.41	31-March-2023	Retail
0158	61.59	31-March-2023	Retail
0010	270.57	30-April-2023	Banana
0014	376.16	30-April-2023	Banana
0015	184.73	30-April-2023	Banana
0017	209.52	30-April-2023	Banana
0039	218.99	30-April-2023	Banana
0044	153.78	30-April-2023	Banana
0091	331.14	30-April-2023	Banana
0111	123.00	30-April-2023	Banana
0113	204.25	30-April-2023	Banana
0122	139.32	30-April-2023	Banana
0128	90.43	30-April-2023	Banana
0136	78.68	30-April-2023	Banana
0137	113.37	30-April-2023	Banana
0157	51.18	30-April-2023	Banana
0158	63.20	30-April-2023	Banana
0010	268.28	30-April-2023	Retail
0014	322.93	30-April-2023	Retail
0015	179.35	30-April-2023	Retail
0017	194.84	30-April-2023	Retail
0039	218.99	30-April-2023	Retail
0044	153.64	30-April-2023	Retail
0091	321.59	30-April-2023	Retail
0111	122.66	30-April-2023	Retail
0113	204.25	30-April-2023	Retail
0122	114.12	30-April-2023	Retail
0128	90.42	30-April-2023	Retail
0136	78.68	30-April-2023	Retail
0137	113.37	30-April-2023	Retail
0157	51.18	30-April-2023	Retail
0158	63.20	30-April-2023	Retail
0010	269.79	31-May-2023	Banana
0014	483.19	31-May-2023	Banana
0015	176.85	31-May-2023	Banana
0017	225.53	31-May-2023	Banana
0039	221.21	31-May-2023	Banana
0044	158.10	31-May-2023	Banana
0091	320.64	31-May-2023	Banana
0111	128.08	31-May-2023	Banana
0113	197.06	31-May-2023	Banana
0122	169.61	31-May-2023	Banana
0128	85.24	31-May-2023	Banana
0136	83.05	31-May-2023	Banana
0137	116.30	31-May-2023	Banana
0157	51.16	31-May-2023	Banana
0158	61.40	31-May-2023	Banana
0010	264.70	31-May-2023	Retail
0014	318.27	31-May-2023	Retail
0015	175.69	31-May-2023	Retail
0017	193.69	31-May-2023	Retail
0039	221.21	31-May-2023	Retail
0044	157.93	31-May-2023	Retail
0091	319.40	31-May-2023	Retail
0111	127.96	31-May-2023	Retail
0113	197.06	31-May-2023	Retail
0122	136.76	31-May-2023	Retail
0128	85.22	31-May-2023	Retail
0136	83.05	31-May-2023	Retail
0137	116.27	31-May-2023	Retail
0157	51.16	31-May-2023	Retail
0158	61.40	31-May-2023	Retail

Output Has to be in Matrix (we Can have any Date after 31st March 2023)

Row Labels	31-March-2023	30-April-2023	31-May-2023	Diff  may _ Mar	Diff Apr - Mar	Diff May - Apr
Banana	2564.15	2608.32	2747.21
0010	265.61	270.57	269.79
0014	383.13	376.16	483.19
0015	180.23	184.73	176.85
0017	203.75	209.52	225.53
0039	214.21	218.99	221.21
0044	149.86	153.78	158.1
0091	320.46	331.14	320.64
0111	121.48	123	128.08
0113	200.26	204.25	197.06
0122	132.47	139.32	169.61
0128	90.66	90.43	85.24
0136	77.86	78.68	83.05
0137	110.17	113.37	116.3
0157	52.41	51.18	51.16
0158	61.59	63.2	61.4
Retail	2432.22	2497.5	2509.77
0010	264.46	268.28	264.7
0014	304.82	322.93	318.27
0015	174.67	179.35	175.69
0017	186.86	194.84	193.69
0039	214.21	218.99	221.21
0044	149.5	153.64	157.93
0091	317.04	321.59	319.4
0111	120.85	122.66	127.96
0113	200.26	204.25	197.06
0122	106.91	114.12	136.76
0128	90.61	90.42	85.22
0136	77.86	78.68	83.05
0137	110.17	113.37	116.27
0157	52.41	51.18	51.16
0158	61.59	63.2	61.4

[lbendlin]

You can use a graphical solution with a custom total

see attached

[MMudasir]

Can we do it with out filters

[lbendlin · Accepted solution]

depends on how many comparisons you want. If it is only the largest and smallest dates then yes.

[MMudasir]

how

[lbendlin]

Remove the slicer visual