Forum Discussion
Movement column between 2 rows
Hi, I am having trouble adding a movement column in power query using M which will update the status of a person. If that person is no longer a ST, Jules per exemple, it should deduct -1 i...
Hi,
I tried this solution, but It wouldn't work with my third data line (id #123). The status before is not null which will interfere with the conditional column. Also, I think that the date is also something to take into consideration.
Thank you for your time !
HI hitman_421 ,
Based on how I read your first comment, I was thinking that your only criteria was the one field. Ok, then this is still relatively easy. In Power Query make a Custom Column with an if statement. Something like : if ([Status] = "x" and [TaskBaselineFinishDate] <> null) then 1 else -1