Forum Discussion

bnisbet's avatar
bnisbet
Frequent Visitor
9 years ago
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((...
Need Help
  • Dog's avatar
    Dog
    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 + ClosedVal

     

    it may not be what you are after but it might be of some assistance. 

Habib's avatar
Habib
Continued Contributor
9 years ago

Seems something wrong in highlighted area.

 

 

 

 

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    9 years ago

    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 :)

    • bnisbet's avatar
      bnisbet
      Frequent Visitor
      9 years ago

      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!

      • Dog's avatar
        Dog
        Responsive Resident
        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 + ClosedVal

         

        it may not be what you are after but it might be of some assistance.