Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

if statement error

Jump to Best Answer
  • 1.  if statement error

    Posted 4 days ago
      |   view attached
    Thank you in advance for the help. Writing a simple if statement and I receive an error. I tried in Power Query using M and in Power BI desktop using DAX, I get the same Token Right Paren error. See screenshot.

    Thank you again.

    ------------------------------
    Kirk Braukmann
    BI Specialist
    Peterson Farms Seed
    Harwood ND
    701-282-7476
    ------------------------------


  • 2.  RE: if statement error
    Best Answer

    Gold Contributor
    Posted 4 days ago
    PQ "if" statements don't need parens... move last closed paren after "null" and you should be fine.

    ------------------------------
    Danny Dennison, MCSA
    http://bit.ly/MCSA_BI
    Business Intelligence Analyst | MCSA: BI Reporting
    Reynolds Lake Oconee
    Greensboro, GA
    7064671624
    ------------------------------



  • 3.  RE: if statement error

    Posted 4 days ago
    Thank Danny! You were a big help today.

    ------------------------------
    Kirk Braukmann
    BI Specialist
    Peterson Farms Seed
    Harwood ND
    701-282-7476
    ------------------------------



  • 4.  RE: if statement error

    Gold Contributor
    Posted 4 days ago
    Glad to help! Thanks.

    ------------------------------
    Danny Dennison, MCSA
    http://bit.ly/MCSA_BI
    Business Intelligence Analyst | MCSA: BI Reporting
    Reynolds Lake Oconee
    Greensboro, GA
    7064671624
    ------------------------------