Forum Discussion
ManeeshaY123
3 years agoNew Member
undefined
- 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.
2 Replies
- tamerj1Community Champion
Hi ManeeshaY123
What is the data type of the Year Month column? Can you provide a sample or a screenshot of your table? - FreemanZSuper User
hi ManeeshaY123
I have some difficulty following you. Could you reorganize your language?