IF/DAX Statement

[bnisbet]

Hey,

Trying to write the following statement, comes up my syntax is wrong though?

Just wondering if anyone could point out where I am going wrong???

= IF (Opportunity[Financial Year] = Year((MONTH (Opportunity[ActualCloseDate]) <4, Year(), Year() + 1 )), (Opportunity[ActualCloseDate]), 0)) + (If (Opportunity[Pipeline Reporting Status] = "E) Potential" AND(Opportunity[Status Code] = "live", Opportunity[EstimatedValue.Value]), 0)))

Thanks!

[CahabaData]

you have 2 compares here:

IF (Opportunity[Financial Year] = Year((MONTH (Opportunity[ActualCloseDate]) <4

that needs to be split apart with an AND

[Habib]

Seems something wrong in highlighted area.

[Phil_Seamark]

I think there is more wrong that just the highlighted area.

Are you trying to create a calculated measure or column?

Can you post your PBIX file, or a link to a cut down version with a brief description of what you are trying to do?

Phil 🙂

[bnisbet]

@Phil_Seamark@Habib 

I am trying to create a measure with the Following Contions:

When an Opportunity has closed within the Finanical Year and the second conition is when an Opportunity is live and has a reporting status of "E) Probable". The measure will then take the Opportunties Values and calculate the total.

Thanks for your help!

[Dog · Accepted solution]

Hi @bnisbet

it's quite difficult to give you exactly the right statement so replace column names as required. 

There are a couple of options. the easiest (from a readability point of vew) is to break out the two calculate statements and add them together at the end. I'm guessing at some of the column names. 

MyMeasure :=
VAR ProbableVal =
CALCULATE (
Opportunity[EstimatedValue],
Opportunity[Pipeline Reporting Status] = "E",
Opportunity[Status Code] = "Live"
)
VAR ClosedVal =
CALCULATE (
Opportunity[ActualClosedValue],
DATESYTD ( Opportunity[ActualClosedDate], "03/31" ),
Opportunity[Status Code] = "Closed"
)
RETURN
ProbableVal + ClosedVal

it may not be what you are after but it might be of some assistance. 

[bnisbet]

@Dog That was a massive help!

After playing about with it a bit, calculates the values!

Thanks

[Dog]

great stuff!