I'm importing data from another report that I drop into a PowerQuery folder source.
I have two columns showing a start date and an end date.
I would like to add a third column showing the numeric difference in months between the two dates to a max value of six months (plus days). Anything that is equal to or greater than seven months can be discarded.
I've tried adding a conditional column but can't see how to implement an IF / THEN type condition that allows me to calculate the date difference and remove the row if the condition is met.
I can do this after the table has been produced by PQ using DateDif, applying a filter then deleting the unwanted rows manually - but ideally I'd like to do this as part of the import process.
Anyone know if this is possible?