How is March 2018 determined? Based on the current month of the previous year? Should next month everything be updated until April 2018?
You can create this by doing the following:
Create a mapping table with the new information and use this in combination with an if statement like: If(Period<=$(vCurrentPeriod),Applymap('YourCreatedMappingTable)',Agent & '|' & Segment,0),OldSegment) as New Segment.
March is the fixed month and 2018 is max Year from the available data. Data will come on monthly basis. Once we receive March data we have to take Max Year march as reference and should update segment until March Max Year, also, It should not update from April Max Year to Feb next year.
I’m facing issues in getting Max year and month as March in vCurrentPeriod. I got the max year in one variable and month number in another variable and I created one more variable combining the max year and march. When I use in if condition, it is not working as expected