Calculate the cost difference between months

Question

Hi everyone,&nbsp;&nbsp;I need to be able to calculate the cost difference between months. Everything I've tried so far hasn't worked.Due to the sensitive nature, I can't provide a .pbix file, but there's an sample of the data below.The only months data I've been given is Feb/Apr/May. I need the difference of the cost of each category from month to month.Any help would be massively appreciated.&nbsp;CheersIan.CategoryMonthCostQuantityAA01-May-23£0.23141AA01-Apr-23£0.16101AA01-Feb-23£0.1699AA01-May-23£0.0955AA01-May-23£0.0955AA01-Feb-23£0.0953AA01-Feb-23£0.0531AA01-Apr-23£0.0530AA01-Feb-23£0.0319AA01-Apr-23£0.0318AA01-May-23£0.0317AA01-Apr-23£0.018AA01-Feb-23£0.016AA01-Feb-23£0.015AA01-May-23£0.015AA01-Feb-23£0.003AA01-May-23£0.002AA01-Feb-23£0.001AA01-Apr-23£0.001AA01-Feb-23£0.000AA01-Feb-23£0.0065AA01-May-23£0.00127AA01-Apr-23£0.0068AB01-Apr-23£37.43136AB01-May-23£20.9879AB01-Apr-23£17.9065AB01-Apr-23£16.8461AB01-Apr-23£16.6662AB01-May-23£9.1534AB01-Apr-23£7.3026AB01-Apr-23£4.9118AB01-Apr-23£4.7117AB01-Apr-23£4.2015AB01-Apr-23£3.7614AB01-Apr-23£1.505AB01-Apr-23£1.144AB01-Apr-23£0.933AB01-Apr-23£0.763AB01-May-23£0.723AB01-Apr-23£0.572AB01-May-23£0.532AB01-Apr-23£0.311AB01-Apr-23£0.261AB01-Apr-23£0.231AB01-Apr-23£0.221AB01-Apr-23£0.221AB01-Apr-23£0.171AB01-Apr-23£0.141AB01-Apr-23£0.120AB01-Apr-23£0.120AB01-Apr-23£0.100AB01-Apr-23£0.100AB01-Apr-23£0.080AB01-Apr-23£0.060AB01-Apr-23£0.050AB01-Apr-23£0.040AB01-Apr-23£0.030AB01-Apr-23£0.000AB01-May-23£0.000AB01-Apr-23£0.000AB01-Apr-23£0.000AB01-Apr-23£0.000AB01-Apr-23£0.000AB01-Apr-23£0.000AB01-Apr-23£0.000AB01-May-23£0.000AB01-Apr-23£0.000AB01-Apr-23£0.000AB01-Apr-23£0.000AB01-Apr-23£0.000&nbsp;

mlsx4 · Answer

Power BI example&nbsp;I think this is what you need, but I don't know if I have understood correctly your question. Tell me if you have any problem to download it

nerf_herder · Answer

mlsx4&nbsp;thank you for your reply. I've replicated your solution into my report and it's not looking right for me.&nbsp;&nbsp;

mlsx4 · Answer

Wow, I don't know what is happening but... Do you have a calendar table? Have you check the value of TotalLastMonth?&nbsp;

Forum Discussion

Calculate the cost difference between months

3 Replies

Related content

Dynamic Calculation Different Period

Different Calculations

1. How to add two different calculated columns of two different table

Calculating Differences

How to add two different calculated columns of two different table

Category	Month	Cost	Quantity
AA	01-May-23	£0.23	141
AA	01-Apr-23	£0.16	101
AA	01-Feb-23	£0.16	99
AA	01-May-23	£0.09	55
AA	01-May-23	£0.09	55
AA	01-Feb-23	£0.09	53
AA	01-Feb-23	£0.05	31
AA	01-Apr-23	£0.05	30
AA	01-Feb-23	£0.03	19
AA	01-Apr-23	£0.03	18
AA	01-May-23	£0.03	17
AA	01-Apr-23	£0.01	8
AA	01-Feb-23	£0.01	6
AA	01-Feb-23	£0.01	5
AA	01-May-23	£0.01	5
AA	01-Feb-23	£0.00	3
AA	01-May-23	£0.00	2
AA	01-Feb-23	£0.00	1
AA	01-Apr-23	£0.00	1
AA	01-Feb-23	£0.00	0
AA	01-Feb-23	£0.00	65
AA	01-May-23	£0.00	127
AA	01-Apr-23	£0.00	68
AB	01-Apr-23	£37.43	136
AB	01-May-23	£20.98	79
AB	01-Apr-23	£17.90	65
AB	01-Apr-23	£16.84	61
AB	01-Apr-23	£16.66	62
AB	01-May-23	£9.15	34
AB	01-Apr-23	£7.30	26
AB	01-Apr-23	£4.91	18
AB	01-Apr-23	£4.71	17
AB	01-Apr-23	£4.20	15
AB	01-Apr-23	£3.76	14
AB	01-Apr-23	£1.50	5
AB	01-Apr-23	£1.14	4
AB	01-Apr-23	£0.93	3
AB	01-Apr-23	£0.76	3
AB	01-May-23	£0.72	3
AB	01-Apr-23	£0.57	2
AB	01-May-23	£0.53	2
AB	01-Apr-23	£0.31	1
AB	01-Apr-23	£0.26	1
AB	01-Apr-23	£0.23	1
AB	01-Apr-23	£0.22	1
AB	01-Apr-23	£0.22	1
AB	01-Apr-23	£0.17	1
AB	01-Apr-23	£0.14	1
AB	01-Apr-23	£0.12	0
AB	01-Apr-23	£0.12	0
AB	01-Apr-23	£0.10	0
AB	01-Apr-23	£0.10	0
AB	01-Apr-23	£0.08	0
AB	01-Apr-23	£0.06	0
AB	01-Apr-23	£0.05	0
AB	01-Apr-23	£0.04	0
AB	01-Apr-23	£0.03	0
AB	01-Apr-23	£0.00	0
AB	01-May-23	£0.00	0
AB	01-Apr-23	£0.00	0
AB	01-Apr-23	£0.00	0
AB	01-Apr-23	£0.00	0
AB	01-Apr-23	£0.00	0
AB	01-Apr-23	£0.00	0
AB	01-Apr-23	£0.00	0
AB	01-May-23	£0.00	0
AB	01-Apr-23	£0.00	0
AB	01-Apr-23	£0.00	0
AB	01-Apr-23	£0.00	0
AB	01-Apr-23	£0.00	0