Method 1 is quick and requires only a few steps, but might run slowly on large datasets. Method 2 requires a few more steps but is likely to run more efficiently if you have a lot of data.
Subscribe: https://www.youtube.com/channel/UCiYjpuUaSfkvdZkmtDU7JRw
#power-query