Forum Discussion

ArchStanton's avatar
ArchStanton
Icon for Power Participant rankPower Participant
4 years ago
Solved

DAX IF Statement producing errors highlighted in red font

Hi, I have this written this DAX code but its producing the red error bar as per screenshot and I'm not sure why? Also, could this be better written using Variables possibly?     Into Are...
Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

    ArchStanton 
    Yes sir, if you have got the correct results already then don't worry about it.

ArchStanton's avatar
ArchStanton
Icon for Power Participant rankPower Participant
4 years ago

Thanks, writing it like this is definitely easier to understand or possibly debug in future.

The DAX still produces errors though:

 

 

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

    ArchStanton 
    What does the error say? Are you sure you are creating a calculated column not a measure?

    • ArchStanton's avatar
      ArchStanton
      Icon for Power Participant rankPower Participant
      4 years ago

      I'm still learning PowerBI so please bare with me. 

      I can't see an error message but In the right hand corner this RED box appears when I go to the end of the code on line 14:

      (and the FunctionalArea names are all in Red Font - does that not sugeest a problem)?

       

      This is a new column that will contain only dates that I will use on my visuals.

       

      Hope that makes sense?

      • tamerj1's avatar
        tamerj1
        Icon for Community Champion rankCommunity Champion
        4 years ago

        ArchStanton 
        Two possibilities I can think of. Either you are creating a measure by mistake or you are creating the column in the another table. In order to see the error you need to hit "Enter" and see the error message at the botom of formula box.