Forum Discussion
Measure development
Hi all, I am seeking support with creating a measure: ACCEPTANCE CRITERIA: calcualte the values in the project_details table from the total Value column when the realization start month is 2...
Nazar11 Hi! Try adjust the measure like:
Total Values =
SUMX(
FILTER(
project_details,
YEAR(project_details[Realization Start Month]) = 2025 &&
project_details[Phase] = "Execution"
),
VAR ProjectCurrency = project_details[Project Currency]
VAR SelectedCurrencyTo = SELECTEDVALUE(exchange_rate[Currency To])
VAR SelectedYear = SELECTEDVALUE(ASP_versions[Year])
VAR ExchangeRate =
LOOKUPVALUE(
exchange_rate[Exchange Rate],
exchange_rate[Currency From], ProjectCurrency,
exchange_rate[Currency To], SelectedCurrencyTo,
exchange_rate[Rate Period], SelectedYear
)
RETURN project_details[Total Value] * ExchangeRate
)
BBF