Add "IF" before calculate

[Anonymous]

hi all,

I would appreciate your help (:

I did not find the way that can be added IF before the calculation ,,

For example:

Actual =

var maxMonthSelection = value('0 - Measure'[check month])

var yearselection = 2019

return

----if (1=1,

CALCULATE( sum('9 - Controling'[Actual Amount] ), FILTER(All('3 - Date'), value('3 - Date'[Year]) = yearselection && value('3 - Date'[Monthnumber]) <= maxMonthSelection ))

---else

CALCULATE( sum('9 - Controling'[Actual Amount] ), FILTER(All('3 - Date'), value('3 - Date'[Year]) = yearselection && value('3 - Date'[Monthnumber]) = maxMonthSelection ))

)

Thanks, sin

[MattAllington]

The syntax for if is

IF(true/false condition, result if true, result of false)

all 3 of these parameters can include a calculate function.