Help with Price Increase Calculations in Power BI

[Syndicate_Admin]

Of course, here's the text without that part:

I need help in Power BI to compare price increases in contracts over time.

I have a table called "Contract Increases" that contains dates and the prices paid. However, payments are not made every month for certain contracts; Sometimes there are lapses of up to 6 months without payments.

The "Contract Increases" table only records the months in which a payment was made and the corresponding year. To visualize a complete timeline per contract, I generated a new related table called "Calendario_Contract_Increases".

Then, I related the "Calendario_Contract_Increases" table to "Contract Increases" through the date column. My goal now is to calculate the percentage of price increase for each contract over the previous month, without taking into account the months with no records.

The complication is that some contracts could have had payments in January and then July, creating empty months in between. Calculating the percentage increase in these empty months would give 0%, which does not reflect reality. Therefore, I need a way to calculate the percentage increase only in months with posted prices and make sure that the previous month has a posted price.

I need help figuring out whether I need to create a new column or a new measure in Power BI to accomplish this, and also the proper format for these measures or columns. Thank you!

In this screenshot, the comparison with a month ago looks correct, but I'm looking for the one that compares between months that have values, attached image.

In this case, you don't have prices every month, just certain months and I want to calculate that increase.

Best regards

Richard Campos B

[MFelix]

Hi @Richard-Campos ,

For this you need to select the row that has values not based on the previous month but on the previous selected value.

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.