topic Re: undefined in DAX Commands and Tips

undefined

ManeeshaY123 — Sun, 08 Jan 2023 14:34:38 GMT

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.

tamerj1 — Sun, 08 Jan 2023 14:45:20 GMT

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

FreemanZ — Sun, 08 Jan 2023 14:46:20 GMT

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