Forum Discussion
Insert row in M query based on condition
Hello experts, need some help. I already spent some time on it and still am not able to figure out. In power query, i need to insert rows, something like if not text.contains ([field1],"value1" and ...
thanks, i found a workaround, not a good one, but will work probably.
I just inserted rows [field1] = "value1", [field2] = 0 and then gruped by to keep max row value for field 2 for each value in field1. That way when data source has [field1] = "value1", [field2] = 1, it would pick up data source one, and when not, then will keep [field1] = "value1", [field2] = 0 row.
If anybody has better one, please post.