Forum Discussion
IF/DAX Statement
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.
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!
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.