I have 2 tables with many to many relation and i want to create a calculated field.
In Field Loc, for the value TKT the Zone field value should be changed to ME for Date later than 01/05/2016. So any data before that should be unchanged.
if(Loc = 'TKT' AND Date >= 01/05/2016, 'ME', Zone) as Zone
To create a calculated field on Dim table, the date field is require. Both the tables are many to many relation, so joining is not the write solution.
I though of creating a flag to identify the max Date available in the model for the value TKT. But not sure how to achieve this.
