Estou postando porque todas as respostas são mais complexas do que deveriam para o erro:
Add-Migration : The term 'Add-Migration' is not recognized as the name of a cmdlet
Basta instalar o pacote Tools com o NuGet:
Install-Package Microsoft.EntityFrameworkCore.Tools
