replace nan with 0 power query. There are any references about replace nan with 0 power query in here. you can look below.