Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
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.
Please help.
Please provide some inputs. It would be very helpful.