Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
NewStep=Table.AddColumn(PreviousStepName,"Invoice Date",each Date.AddYears([Due Date],-[Age]))
NewStep=Table.AddColumn(PreviousStepName,"Invoice Date",each Date.AddYears([Due Date],-[Age]))