undefined

[ManeeshaY123]

• 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.

[FreemanZ]

hi @ManeeshaY123 

I have some difficulty following you. Could you reorganize your language?

[tamerj1]

Hi @ManeeshaY123 
What is the data type of the Year Month column? Can you provide a sample or a screenshot of your table?