Forum Discussion
Calculated column
Hello All I need your help in creating the calculated column as below. If Table 1 Product Code = Table 2 Product code and Table 1 product type 16 = “1” in (table 3 city type) then Match...
I know this isn't directly answering your question, but I recommend setting up the relationship in the data model itself. Link the Product Codes together in the data model, and link the City Codes together in the model.
If you do that, then you don't need a formula, you can simply grab the Country code and it will work automatically.
If you need to filter by Product Type 16, you can add that as a filter to the visual.
viviank - I need to create a calculated column for getting the desired result. The visual filter will not work.
Also, in table 3 there are cities which had got different countries.