Help With Formula

Hi Anonymous 

Here’s how you can do it:

1. Load Your Data

2. Define Parameters
If you want to set parameters like increase/decrease percentage, month, and criteria, you can use Power BI parameters

3. Create Calculated Columns or Measures
Assume you have a separate table called 'PriceTable' with columns 'Month', 'Criteria', and 'Price'.To find the price based on month and criteria, and then calculate the final value:

(1) Create a Relationship between your main table and 'PriceTable' based on 'Month' and 'Criteria' (if applicable).

(2) Create a Measure for Final Value:

FinalValue =
VAR Adjusted = [OriginalValue] * (1 + [IncreasePercentage])
VAR Price =
CALCULATE(
MAX(PriceTable[Price]),
FILTER(
PriceTable,
PriceTable[Month] = [Month] &&
PriceTable[Criteria] = [Criteria]
)
)
RETURN
Adjusted * Price

Best Regards,

Jayleny

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