Forum Discussion
IF/DAX Statement
- 9 years ago
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.
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.