Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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.
you have 2 compares here:
IF (Opportunity[Financial Year] = Year((MONTH (Opportunity[ActualCloseDate]) <4
that needs to be split apart with an AND
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_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!
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.
@Dog That was a massive help!
After playing about with it a bit, calculates the values!
Thanks
great stuff!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |