Forum Discussion

Michalison's avatar
Michalison
Helper II
2 years ago
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...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    Michalison 

    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
Uzi2019's avatar
Uzi2019
Community Champion
2 years ago

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!

 

Michalison's avatar
Michalison
Helper II
2 years ago

I have re-done it as  

still getting an error

  • Uzi2019's avatar
    Uzi2019
    Community Champion
    2 years ago

    Hi Michalison 

    Take the calculated column.
    right click on 3 dots > then select new column

     

    and write the formula which i have shared.

     

     

  • Uzi2019's avatar
    Uzi2019
    Community Champion
    2 years ago

    Hi Michalison 
    I got your problem

     

    You complted column is not in Date data type. It is in text format.

    Please convert your complted column into date column format so that my dax formula will work for you.

     

    Process> select your complted column > change data type > Date

     

    I hope I answered your question!