Forum Discussion
Delete Row after condition is met
I am trying to delete status "P" row once there is a date in due date actual for status "I". I can not seem to wrap my head around this one. Any support or help is much needed. Status I...
HotChilli
Community Champion
Community ChampionIn Power Query?
It will be a Table.SelectRows statement and the way to get the correct syntax is to get powerbi to generate it for you by filtering from the column header e.g. the Remove Empty option and then editing it to retain rows that meet 2 conditions: status not equal to I and date not equal to null (you'll have to write the right syntax for that bit)