Forum Discussion

Michalison's avatar
Michalison
Icon for Helper II rankHelper 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
ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
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
  • Michalison's avatar
    Michalison
    Icon for Helper II rankHelper II
    2 years ago

    Yes thank you I tried both methods and they both worked  many thanks

    • ryan_mayu's avatar
      ryan_mayu
      Icon for Super User rankSuper User
      2 years ago

      you are welcome