Forum Discussion
IF/DAX Statement
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!
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 + ClosedValit may not be what you are after but it might be of some assistance.
7 Replies
Seems something wrong in highlighted area.
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 :)
Phil_SeamarkHabib
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!
you have 2 compares here:
IF (Opportunity[Financial Year] = Year((MONTH (Opportunity[ActualCloseDate]) <4
that needs to be split apart with an AND
