A dimension table have 3 columns that having, 1.productcode, 2.MRP, 3.Month year. MRP will change month wise.
For example Product code 1234 having multiple rows that, Month January, February, March having MRP 10/- and same product id MRP have changed in April month. Now I need add a calculated column that for Jan, Feb, March month rows in end date column april1st have to recod how can write dax logic here. If any one help me here I would be very thankful to you.
