Hello,

I am relatively new with DAX formulas so bare with me a little bit. I am using Visual Studio 2012 and creating a tabular model. I have imported a table based off a query another person sent to me. One of my columns has an item number and another has the quantity of the item. I need to create another column and write a formula so that it returns a Y or N based on if the item number has a negative quantity or not. Thoughts?

Hi areno,

Based on your description >>I need to create another column and write a formula so that it returns a Y or N based on if the item number has a negative quantity or not.<<, I suppose you can use Logical Data Analysis Expressions (DAX) functions to get your result.

Logical Data Analysis Expressions (DAX) functions act upon an expression to return information about the values or sets in the expression. For example, you can use the IF function to check the result of an expression and create conditional results.

Please refer to this link about how to use Logical DAX functions:
http://social.technet.microsoft.com/wiki/contents/articles/682.powerpivot-dax-logical-functions.aspx

This link is about types of DAX functions:
http://social.technet.microsoft.com/wiki/contents/articles/677.powerpivot-data-analysis-expressions-dax-language.aspx

Hope it's helpful.

Regards,

Emi Zhang
TechNet Community Su