Forum Discussion
Solved
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((...
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.
