Create calculated column in Live connection
Hello All, I have 2 tables, Table 1 is live connection(Using existing dataset) and Table 2 is import file. The Employee ID present in import file should be shown as "Flag - Internal", and for other records should be shown as "External" or "Blank". We have to bring that Flag column from table 2 to table 1. Using RELATED function we can achieve this but since Table 1 is live connection unable to create Calculate column and Calculate Table. Using relationship between these 2 table if we directly drag and drop the Flag column in a table visual, data will filtered out where Flag = Internal. Flag = External won'tbe appeared in the visual. I believe it should be handled in Measure. Please advice how to achieve this measure.DAX - Calculated column based on IF condition
Hi Team, I have a scenario to achieve in DAX. The mentioned is the requirement. The Training "T1" should be mapped only to Role 1. If other Role contains the T1 value it should be "Null". Other values in Training can be same. Only for T1 we need to achieve this. Even if data has 100 roles, if any role contains T1 value then it should be "Null" all other values are similar. Please advice to achieve this output.
