Forum Discussion

FarisA's avatar
FarisA
Regular Visitor
4 years ago
Solved

Need Help Invoice date Colum from Due Date and Age

If I have Due Date and Age, how do I get the Invoice Date column through the Power Query Editor.
So I need a new column Due Date minus Age.

Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    4 years ago

    NewStep=Table.AddColumn(PreviousStepName,"Invoice Date",each Date.AddYears([Due Date],-[Age]))

1 Reply

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion
    4 years ago

    NewStep=Table.AddColumn(PreviousStepName,"Invoice Date",each Date.AddYears([Due Date],-[Age]))