Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How make IF returns value from column

Hello! I'm newbie at Power BI and Im struggling to solve a simple question. I did a search on forum but there is so much information and i didn't find what i need especifically.   So let's go. ...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, Anonymous 

    In my opinion, I think the error is because of the data type.

    Please try to change the data type of DDL Pending QTY to TEXT, and try the below for creating a new column.

     

    Coluna = IF('Base SAP'[DDL Pending Qty] = "0", "NOK", 'Base SAP'[DDL Pending Qty])
     
     

    Hi, My name is Jihwan Kim.


    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.


    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Sure!

 

PBIX 

 

But you'll need some explanations.

I created a generic table to explain my issue.

 

On my pbix file, i have to do the IF with the column "DDL Pending Qty", so:

Column = IF('Base SAP'[DDL Pending Qty] = 0, "NOK", 'Base SAP'[DDL Pending Qty])
Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, 

Thank you for your message.

I think you shared a link address of your PBI service website, which I cannot access.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Sorry 😞

     

    How can i share my sample pbix file's link?

    Sorry for this kind of question