Forecast Incremental Values with POWER Dax

Peru123 — Fri, 12 May 2023 04:46:39 GMT

Hello everyone,

I am trying to calculate incremental values based on the latest value.

As there was a community post very similar to my case, I customized the sample partially.

*some of the VAR or column names doesn't make sense as I kept the names from the sample

However, the "else" part of the IF syntax is not calculating correctly.

Please tell me where I am wrong and how I could fix this.

[Sample]

Using the parameter, Growth %

fy1+(fy2/365) & Forecast = VAR _lastSalesMonth = [Last Sales Month (Last Updated)] VAR _lastMonthTotal = CALCULATE(SUM('indices_eps (Local)'[fy1+(fy2/365)]),ALL('DateTable'),'DateTable'[Date]=_lastSalesMonth) VAR _thisMonth = MAX('DateTable'[Date]) VAR _power = DATEDIFF(_lastSalesMonth,_thisMonth,DAY) RETURN IF(_thisMonth<=_lastSalesMonth,SUM('indices_eps (Local)'[fy1+(fy2/365)]),_lastMonthTotal*POWER(1+[Growth % Value]/100,_power))

[My ver. which doesn't calculate "else"]

colmn calculations are the measure calculations with the formula shown as the column name

Actual & Forecast = VAR _lastUpdatedDate = [Last Updated Date] VAR _lastUpdatedValue = CALCULATE(SUM('indices_eps (Local)'[fy1+(fy2/365)]),ALL('DateTable'),'DateTable'[Date]=_lastUpdatedDate) VAR _thisMonth = MAX('DateTable'[Date]) VAR _power = DATEDIFF(_lastUpdatedDate,_thisMonth,DAY) RETURN IF(_thisMonth<=_lastUpdatedDate,SUM('indices_eps (Local)'[fy1+(fy2/365)]),_lastUpdatedValue*POWER(1+[((fy2-fy1)/fy1)/365)],_power))

I appreciate your kind advise and help.

Thank you.

Peru

topic Forecast Incremental Values with POWER Dax in DAX Commands and Tips

Forecast Incremental Values with POWER Dax