Forum Discussion
Microsoft Employeeshift date 6 months into the future
hey there, i am trying to add another column where the date are 6 month in the future from the current drop date column, but when i do dax function dateadd it tells me i have duplicate values which is not allowed, i dont have access to power query in this report, what should i do to get around this?
thank you
sudeng123 , dateadd will not work , if dates are not there in table , try like
New column
Date(year([drop_date]),month([drop_date])+6,day([drop_date]))
watch my video for that: https://www.youtube.com/watch?v=9qiRivlBv8w
2 Replies
- amitchandak
Super User
sudeng123 , dateadd will not work , if dates are not there in table , try like
New column
Date(year([drop_date]),month([drop_date])+6,day([drop_date]))
watch my video for that: https://www.youtube.com/watch?v=9qiRivlBv8w
sudeng123very slick solution there sir, thank you very much.