multiply the year-on-year inflation rate per month to a sum of amounts

[jguillamet]

Hi , 

How to multiply the monthly inflation index to the sum of amounts grouped monthly?

Emission table

ID	Day	Month	Year
1	5	1	2022
2	6	1	2022
3	8	1	2022

Billing table

IdBilling	IDEmission	$
1	1	10
2	2	20
3	3	20

IPC Table

(compared to the month of the previous year)

Month	Year	%
1	2023	91.3
2	2023	95.7

Result

Month	Year	%	$
1	2022	91.3	95.65

The idea is obtain the sum of the month a year ago and multiply by the inflation index to know when the current month should be added and be equal to inflation

[Anonymous]

Hi @jguillamet ,

Could you please provide more details? How to get the 95.65 in the result table? What is the relationship among the tables?

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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

[jguillamet · Accepted solution]

Sorry, the very slow dashboard response was because I was using Direct Query when it wasn't necessary. But using Import changed the interop.
Thank you