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]))

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
4 years ago

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