cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Add "IF" before calculate

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

1 REPLY 1

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.  

 

 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors