Forum Discussion
Checking and transforming end date in power query
Hi I have 2 columns start date and end date where i have end dates lesser than start dates. If my end date is before start date I want to replace end date with start date value, thereby the differe...
Anonymous Create a new column (Add Column)
= if [end date] < [start date] then [start date] else [end date]
Then remove your end date column and rename the new column to end date.
Greg_Deckler Thank you so much