topic multiply the year-on-year inflation rate per month to a sum of amounts in DAX Commands and Tips

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

jguillamet — Tue, 04 Apr 2023 15:53:24 GMT

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

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

Anonymous — Thu, 06 Apr 2023 02:23:24 GMT

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.

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

jguillamet — Mon, 22 May 2023 10:43:09 GMT

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