Forum Discussion

learner03's avatar
learner03
Icon for Post Partisan rankPost Partisan
3 years ago
Solved

If statement for matching text from other table list

I have 2 Tables- I need to write a measure or create a column for if the Location is India and count less then 10 and postcode belong to the postcode list, then Count*50. ( to be notes that in actu...
Need Help
  • ChainsawMan's avatar
    ChainsawMan
    3 years ago

    Hi 

    Please try the following DAX to create a new column.

    Column = IF(
    'Order'[Count]<10 && 'Order'[Location] = "India" && 'Order'[Postcode] in VALUES(PostCode[Postcode]),
    'Order'[Count]*50,
    'Order'[Count]
)
ChainsawMan's avatar
ChainsawMan
Icon for Helper I rankHelper I
3 years ago

Hi 

Please try the following DAX to create a new column.

Column = IF(
    'Order'[Count]<10 && 'Order'[Location] = "India" && 'Order'[Postcode] in VALUES(PostCode[Postcode]),
    'Order'[Count]*50,
    'Order'[Count]
)
  • learner03's avatar
    learner03
    Icon for Post Partisan rankPost Partisan
    3 years ago

    ChainsawMan  Thanks . and what is the opposite of this, example NOT In values?