Forum Discussion
Solved
PowerBI Customn column
I want to add a custom column that looks at the completed date i.e. 22/06/2019 looks at years to next course column i.e. 3 then puts a new date in the custom column of 3 years since the complet...
you can try to create a column in PQ (pls make sure the date is in date type)
=Date.AddYears([Completed],[Years until next course])
or use DAX to create a column
Column = EDATE('Table'[Completed],'Table'[Years until next course]*12)pls see the attachment below
hi Michalison
Try calculated column
date new = DATE(YEAR(Sheet1[Date ])+Sheet1[Year Plus],MONTH(Sheet1[Date ]),DAY(Sheet1[Date ]))
I hope I answered your question!
Thank you for your answer I have tried this but get an error
It doesnt seem to like month/day etc