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
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
Yes thank you I tried both methods and they both worked many thanks
you are welcome
